[thelist] MySQL Drivers on Win2K
Michele Foster (WizarDev)
michele at wizardev.ca
Fri Jan 14 09:57:00 CST 2005
I have created a MySQL database at my hosting company. I can access it from
my local machine with MySQL Front and I can access it from another host that
I know offers MySQL too. However, I cannot get it to work locally. The
error message I'm getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/db.asp, line 9
Where line is 9 is the cnn.open statement.
My host said I needed to install the MySQL drivers for Windows, which I
found here and installed.
http://www.mysql.com/products/connector/odbc/
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
I've subsequently stopped and restarted IIS and PWS and rebooted the
machine. I've tried to create File and System DSN entries even though my
connection string is DSN-less. The drivers appear as options under the ODBC
manager.
Still no luck. I'm not sure what else I should do.
Any suggestions greatly appreciated.
Thanks,
Michele
(Please cc any replies as I only read the archives.)
More information about the thelist
mailing list