connection error MYSQL and ASP
Hi,
I'm testing mySQL with ASP, but I can not stablish the connection betwen the ODBC and the ASP. This is the error:
Error Type:
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:
set conn=server.CreateObject("ADODB.Connection")
conn.connectionstring="DSN=faqs"
conn.open
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????
Thanks.
renees
__________________
renees
|