Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: Urgent :why i cant see my asp file in localhost?

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [TCX][MyODBC]Can't connect to MySQL server on '219.93.218.177' (10060)
    why this happen and how to solve the problem?thanks ..i need it urgent.

  2. #2
    Join Date
    Aug 2004
    Posts
    96
    This is a proiblem connecting to the database which could be coming from several things.
    1. Check your user on MySQL, you should have a user created for the database you want to connect under the user administration.

    2. Check your MyODBC connection, there is a test button on it, that should give you an idea of where the problem is.
    3. Check your username and password on your connection settings on your ASP page.

    The best is often to remove the user in the DB, remove the connection and start all over.

    Hope this helps,
    Oli

  3. #3
    Join Date
    May 2005
    Posts
    39
    Quote Originally Posted by shinwai
    why this happen and how to solve the problem?thanks ..i need it urgent.
    Most likely a problem with connection string. Try this:

    Code:
    Dim DSNName
    DSNName = "PROVIDER=MSDASQL;driver={MySQL ODBC 3.51 Driver};server=localhost;option=" & 1 + 2 + 8 + 32 + 2048 + 16384  & ";uid=your_username;pwd=your_password;database=your_db_name;"
    
    Dim Conn
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.open DSNName
    
    'some code
    
    Conn.Close
    Set Conn = nothing

Posting Permissions

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