Page 1 of 1

Access denied for user 'ODBC'@'localhost'

Posted: Wed Feb 16, 2005 4:21 am
by pleigh
hi, i always get this error message
Access denied for user 'ODBC'@'localhost' (using password: NO)
where could be the problem? i checked my syntax but it appears to be ok...

Posted: Wed Feb 16, 2005 5:25 am
by thomas777neo
It usually means that the connection to the database in your site, doesn't have rights to connect to the database.

So the user ODBC in your database does not exist on your database server. Are you using MySQL?

You simply need to change your database connection string to an existing user in the db server, or add the user ODBC@localhost to you db server.

Posted: Wed Feb 16, 2005 6:59 am
by Chris Corbyn
I think he's obviously using ODBC not MySQL... how is your ODBC setup?

Have you included the database you are trying to connect to and given the approrpriate permissions?

Show some up your script too...

Posted: Wed Feb 16, 2005 7:18 am
by thomas777neo
Never presume what a person might be using. And if you have a comment please learn how to spell and get some grammar lessons.

If indeed he / she is using ODBC. The same "rights" and "user" concepts apply.

Posted: Wed Feb 16, 2005 7:47 am
by Trenchant
Most times from my experience it was scripting problems that I had missed. I found this while using ODBC for VB6.

I would suggest have a quick run over your connection script to make sure everything is correct.

Posted: Wed Feb 16, 2005 9:30 am
by feyd
continue using your original threads pleigh.

viewtopic.php?t=30588