SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can't connect to database...

    Hi everyone.
    I have a connection to my database.If my database doesn't require a password everything works well, the Connection is made.
    This is my connection without password:
    Conn.Open "Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=Database;Uid=xxx;OPTION=3;"

    Once I put a password to my username for my database it stops working.
    This is my connection with password:
    Conn.Open "Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=Database;Uid=xxx;Pwd=xxx;OPTION=3;"

    the error message I get is:
    The connection cannot be used to perform this operation.It is either closed or invalid in this context.

    Anyone has a clue how to fix this ?
    Thanks!

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    What server-side language are you using?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm using classic ASP and MySQL

  4. #4
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    Are you able to connect to the database using the same username and password via the MySQL command line?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  5. #5
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes I'm able to connect to mysql database with the MySQL command line.


Bookmarks

Posting Permissions

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