Ok guys i'm back i could not find a cms that is good as the snitz forum. So here is my problem i get this when open forum (yes i know you have answered this befor) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /lnl/forum/inc_header.asp, line 111
I'm using mysql 5.o,(with db name xxxxx.db)iis 5.1 on xp pro machine.I'm using strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=(xxxxxxxxx);user=(XXXX);password=(xxxxxxx);DATABASE=(xxxxxx.db);" '##MySQL w/ MyODBC v3.51. My question is what do i have wrong!!
Thank for the help I didin't have the MyODBC driver after installing driver this new problem. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver]Host 'computer name' is not allowed to connect to this MySQL server. I have searched the net and can't find a fix for this but see alot people have this problem.
This is what i get when try to open forum. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver]Host 'c3po' is not allowed to connect to this MySQL server /lnl/forum/inc_header.asp, line 111
Do you have MySQL administrator installed? If you do, go to the tools menu and choose MySQL Command Line Client. Then, in the dos command window that shows, type:
GRANT ALL ON *.* TO username@'%';
username should be replaced by the username you want to use to connect to the database.
Topic Locked
Posted - 20 June 2007 : 08:58:30
