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

It has been a while since I have contacted a MySQL database from ASP, however it seems like your connection string is wrong. It seems like you are trying to log on to the database as user 'ODBC' and from the machine from where the database is installed (localhost), but without a password ('ODBC'@'localhost' (using password: NO)).

You want to log on as 'root' with the other info you supplied; perhaps you should post your connection string. The error is probably caused by you logging on as a user which hasn't been granted the correct rights in the tables user, host and db in the mysql database.

You can check to see if the user 'ODBC' is at all in the user table.

Hope it helps.

Jacob.

Hi,
thanks for your advice, I coded this:

dim conn
dim conn_string
conn_string = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test001;USER=roo t;PASSWORD=test;OPTION=3;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(conn_string)

But I got this error:
   Error Type:
   Provider (0x8000FFFF)
   Catastrophic failure
Any suggestion??? Do I need configure something???

thanks.

renees

I have e recently connected to a MySQL database using ODBC and I used pretty much the same structure in the connection string, however one small difference; try changing USER to UID.

And remember to close the connection again. That is the nice thing to do.

Hope it helps.

Jacob.

Thanks,
I changed USER for UID, I still got the error:
Error Type:
Provider (0x8000FFFF)
Catastrophic failure

any suggestion?


renees

I had the same problem with the 3.51.10 driver. Downloaded the new driver ( 3.51.11 ) from mysql.com and my problems went away.