MySQL Forums
Forum List  »  Connector/ODBC

Problems with ODBC 5.2 64bit
Posted by: Sandeep Chadha
Date: February 05, 2014 04:15AM

Hi

I have a server where I have installed ODBC 5.2 64 bit driver. As I understand this installs both 64bit and 32bit drivers. I have even verified this by looking into the system32 and syswow64 folders and both have their own odbc32.dll.

Now when I use this in Windows 8 server IIS8, all sites work correctly while in 64bit. Now there is a site that needs to consume a 32bit dll and for this I enable 32 bit applications from the app pool for that site, and doing this the ODBC connection fails.

Now I need to know why is it happening when there is a odbc32.dll present in the syswow64 folder. Also when I use odbcad32.exe to see the installed drivers, I dont see the mysql drivers for 32 bit here.

I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

My connection string is as follows:
Provider=MSDASQL;Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

Please help me as this is very urgent.

Thanks
Sandy



Edited 1 time(s). Last edit at 02/05/2014 04:28AM by Sandeep Chadha.

Options: ReplyQuote


Subject
Written By
Posted
Problems with ODBC 5.2 64bit
February 05, 2014 04:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.