MySQL database is running in Amazon cloud and I have only read-only access. The current server (Oracle Linux 6 with mysql-connector-odbc-5.1.86_64) is pulling data from more than 50 tables MySQL database v 5.6.34 without any issue. I want to upgrade my server OS from Oracle Linux 6 to Oracle 7. Libruncbl$(BITS).a $(LIBS) $(SYS_LIBS) $(SYS_C_LIBS) \ $(CC) $(EXEC_LDFLAG) $(LDFLAGS) -o amain.o $(SUBS) \ # Use the following two lines for an AcuSQL-ENABLED runtime:ĪCUSQL_LIBS = $(ACU_LIBDIR)/libesql.a $(ACUSQL_ODBC_LIB) # AcuSQL-ENABLED runtime or the AcuSQL precompiler:ĪCUSQL_ODBC_LIB = /mysql/mysql-con/mysql/lib/libmyodbc5.so # Enter the name of your ODBC API library below if you want to relink an LDFLAGS = -s $(EXTRA_LDFLAG) /usr/local/lib/libodbcinst.so.1 $(JAVA_FLAG) $(XML_FLAGS) $(EXTFH_FLAGS) -DUSE_RMFM $(EXTRA_CFLAGS) $(ACUSERVER_FLAGS) $(ACUCONNECT_FLAGS) $(ACUSQL_FLAGS) $(EXTSM_FLAGS) \ Now, I'm running out of idea as to what make the libodbcinst.so.1 to be undetected by the system.įollowing is part of the code inside Makefile.ĬC = cc -Ae -mt +DSblended +DD64 -Dinline= -Wl,+s -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE +z However, it still shows the following error. And I also make sure that the libodbcinst.so.1 lib path to be in SHLIB_PATH. I already run test the UnixODBC connection to MySQL using MySQL Connection ODBC and it works fine. The program need libodbcinst.so.1 since it is needed by the libmyodbc5.so. Ld: Can't find dependent library "libodbcinst.so.1" Hi, I'm having problem in running the "make" command for one of my program in HP-UX. Has anybody successfully installed the 32 bit drivers on Windows Server 2016? If I ignore this error and set up the Data Source Name anyway, the application that is trying to connect to the database is throwing the same error, so the problem is not only in the Test button.ĭoes anybody have any suggestions for solving this problem? "Connection Failed Specified driver could not be loaded due to system error 126: The specified module could not be found (MySQL ODBC 5.3 Unicode Driver, C:\Program Files(x86)\MySQL\Connector ODBC 5.3\myodbc5w.dll).:"Īs an additional thing to try I added this path "C:\Program Files(x86)\MySQL\Connector ODBC 5.3" to the Path System Variable as well. When I use the 32-bit Data Source Administrator to create a data source, I get the following error when I test the connection: I also had to manually add some msvcp*.dll files to the C:\Windows\SysWOW64\ folder and added that directory to the Path System Variable. I also installed vcredist2017 (Microsoft Visual C++ 2017 Redistributable (x86) 7). I am trying to set up a connection to a MySQL database from Windows Server 2016.Īfter a lot of trial and error I have installed the driver using this ODBC Connector "mysql-connector-odbc-5.3.8-win32" installer. I don't see any issue, but what else might preclude it from working for them but not me? RsSql = "SELECT RPOA_Number, Association_Name FROM Member WHERE RPOA_Number = " & nID If Request("RPOA_Number") "" and Session("RPOA_Level") = "10" then 'admin used session and request, tenant uses request only Msg = "This Defendant Court record is already in the database!" GoRedirect("admin_main.asp?msg=defendant record added- success")ĪlertRedirect "SUCCESS! \n Court record was successfully \n added to the database.", "tenant_main.asp" "Plaintiff, Dist_Court, Eviction_Judgement_Date, Eviction_Case_Number, Concur_Valid, Concur_Liability, " &_ "Apartment_Complex, Apartment_Number, Defendant_Street1, Defendant_City, Defendant_State, Defendant_Zipcode, " &_ RsSql = "INSERT INTO Court_Rec (Defendant_Firstname, Defendant_Middle, Defendant_Lastname, Defendant_Suffix, " &_ "Eviction_Case_Number ='" & request("Eviction_Case_Number") & "'" "Eviction_Judgement_Date ='" & request("Eviction_Judgement_Date") & "' AND " &_ RsSQL = "SELECT Defendant_ID FROM Court_Rec WHERE " &_ I've had him clear browser cache, and even reboot computer, but issue persists. Problem is, I login to the site and it works for me. court_add.asp, line 40 ( aka set myRS=objConn.Execute(rsSQL) ) Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Ok, so I have this legacy client who reached out to us regarding this error:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |