[thelist] MySQL Drivers on Win2K

[Michele Foster (WizarDev)]

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 DSL-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.)