MySQL Forums
Forum List  »  Connector/ODBC

MyODBC 3.51.23 - Win2K3 x64 Will not connect.
Posted by: Brendan Bailey
Date: February 26, 2008 08:42AM

Hello all,

I have recenetly upgraded to win2k3 x64 from the 32 bit edition. I installed the 64 bit MySQL ODBC driver from the batch file without issue. I then set up and tested a DSN through the ODBC Data Source Administrator which also worked.

However, when trying to access the data base through an ASP classic page using a simple and proven connection string both DSN and DSNLess returns the following error:

"ADODB.Connection error '800a0ea9'

Provider is not specified and there is no designated default provider."

In testing I found that the system appears to be correctly configured to the MySQL configuration requirements, and I made sure that the driver files were not security locked. The system still fails to load the driver:

C:\WINDOWS\system32>myodbc3i -q -s -n"MySQL ODBC 3.51 Driver"
[.\myodbc3i.c][449][WARNING] Could not load (MySQL ODBC 3.51 Driver)

C:\WINDOWS\system32>myodbc3i -q -d -n"MySQL ODBC 3.51 Driver"
Name............: MySQL ODBC 3.51 Driver
DRIVER..........: C:\WINDOWS\system32\myodbc3.dll
SETUP...........: C:\WINDOWS\system32\myodbc3S.dll

Can anyone help me out with this I have been stuck on this for a whole day now!!

Thanks, Brendan

Options: ReplyQuote


Subject
Written By
Posted
MyODBC 3.51.23 - Win2K3 x64 Will not connect.
February 26, 2008 08:42AM


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.