Lunarpages Web Hosting Forum

Author Topic: ADODB.Connection.1 error '80004005'  (Read 3468 times)

Offline alfredo

  • Newbie
  • *
  • Posts: 3
    • http://speakteacher.com
ADODB.Connection.1 error '80004005'
« on: October 02, 2002, 07:23:00 PM »
this is the error i am getting
ADODB.Connection.1 error '80004005'

SQLState: S1000
Native Error Code: 1045
[TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: YES)

the connectionstring is :
connectionstring = "DRIVER={MySQL}; DATABASE=kkk;SERVER=localhost;  USER=hhh;PASSWORD=rrr; OPTION=16386;"

Note: database name, user and  password are not real

but if i am trying connect with a user that i make in the database (diferent to root) why the error show "root@localhost"

Offline SithLegend

  • Jabba the Hutt
  • *****
  • Posts: 738
    • http://neptune.lunarpages.com/~mx1
ADODB.Connection.1 error '80004005'
« Reply #1 on: October 03, 2002, 10:39:00 AM »
i noticed when i created my databsed
and i created 1 user for it

the cpanel showed me the code how to use it on
perl  or php  etc..

have you tried what the cpanels says?

i used it for a webgallery

but the webgallerydid all the work
i just added teh database name
and user and password
"I swear on the soul of my father, Domingo Montoya, you will reach the top alive."

Offline Max

  • Über Jedi
  • *****
  • Posts: 2506
    • Max's website!
ADODB.Connection.1 error '80004005'
« Reply #2 on: October 03, 2002, 12:58:00 PM »
You seem to have the wrong username and database name added to your syntax.

Take another look what the mysql admin creates for you  "[Smile]"

Offline kcasper

  • Newbie
  • *
  • Posts: 1
    • http://www.designerds.net
ADODB.Connection.1 error '80004005'
« Reply #3 on: October 30, 2002, 09:07:00 AM »
Driver={mySQL};Server=localhost;Database=aaa;UID=bbb;PWD=ccc

this string works.

kc
 
 [ October 30, 2002, 05:08 PM: Message edited by: kcasper ]