connection error MYSQL and ASP
I'm testing mySQL with ASP, but I can not stablish the connection betwen the ODBC and the ASP. This is the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
I installed the ODBC Driver and created the DSN. My code in ASP:
the data in the DSN are:
user:root, pwd: faqs, server: localhost, database: dbfaqs
Do I need create a new userid, or what do I need check????