ADODB.Connection.1 error '80004005'

Results 1 to 3 of 3

Thread: ADODB.Connection.1 error '80004005'

  1. #1
    Bramdeman Guest

    Default ADODB.Connection.1 error '80004005'

    I am trying to create a full table, via asp to mysql. When trying to connect, the server returns the following:<BR><BR>ADODB.Connection.1 error &#039;80004005&#039; <BR>SQLState: S1000<BR>Native Error Code: 1045<BR>[TCX][MyODBC]Access denied for user: &#039;; (Using password: YES)<BR>/data2.asp, line 8<BR><BR>lines read:<BR>1<BR>2 dim conn,myDSN<BR>3<BR>4 myDSN="DSN=[DSN i&#039;m using];uid=[proper username];pwd=[proper pwd]"<BR>5<BR>6 set conn=server.createobject("adodb.connection")<BR>7< BR>8 myDSN<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ADODB.Connection.1 error '80004005'

    This is definitely a permission problem. Did you log into the mysql command console as root and "grant all on [db] to identified by pw with grant option, then go back add verify that you have been given the right permissions?<BR>MySQL can be a little finicky in getting the grant tables set up properly.<BR>You might want to even grant all on [db] to big-web@% yada yada yada. That way you won&#039;t have trouble when you deploy it on another server. Need a MySQL book use the one by Paul DuBois. muy excellente.

  3. #3
    Bramdeman Guest

    Default RE: ADODB.Connection.1 error '80004005'

    Dear Gregory,<BR><BR>Thanx a bunch!<BR><BR>Bramdeman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts