Access denied for user 'ODBC'@'localhost'

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Locked
User avatar
pleigh
Forum Contributor
Posts: 445
Joined: Wed Jan 19, 2005 4:26 am

Access denied for user 'ODBC'@'localhost'

Post 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...
User avatar
thomas777neo
Forum Contributor
Posts: 214
Joined: Mon Mar 10, 2003 6:12 am
Location: Johannesburg,South Africa

Post 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.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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...
User avatar
thomas777neo
Forum Contributor
Posts: 214
Joined: Mon Mar 10, 2003 6:12 am
Location: Johannesburg,South Africa

Post 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.
User avatar
Trenchant
Forum Contributor
Posts: 291
Joined: Mon Nov 29, 2004 6:04 pm
Location: Web Dummy IS

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

continue using your original threads pleigh.

viewtopic.php?t=30588
Locked