Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jan 2008
    Location
    Str_web
    Posts
    29
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Remote connection from iis

    hai mates good day..

    Do i need to change anything to connect mysql database which i created on my server from my computer(IIS)?

    I made remote connection to this database from another server and it works fine using the connection string :

    Code:
    dim Mysql_conn
    set Mysql_conn  = Server.CreateObject("ADODB.Connection")
    Mysql_conn.Open "Driver={mySQL ODBC 3.51 Driver}; Server=myweb.com;Database=my_db; USER=User_name; PASSWORD=paswrd;"
    I tried to run same connection string from my computer but it shows an error message like

    Code:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    Guys any pointer for this prob

    Thanks in advance

    Regards
    “There are no failures - just experiences and your reactions to them.”

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,994
    Thanks
    120
    Thanked 76 Times in 76 Posts
    1.did you added ip from this new computer(client) to server allowed ips ?


    administrator--> USER ADMIN--> ADD NEW HOST ...

    2. did you instaled mysql odbc driver on new client ?
    Last edited by BubikolRamios; 02-19-2009 at 11:50 AM.

  • #3
    New Coder
    Join Date
    Jan 2008
    Location
    Str_web
    Posts
    29
    Thanks
    2
    Thanked 0 Times in 0 Posts
    2. did you instaled mysql odbc driver on new client ?
    Thank you for this pointer BubikolRamios...i just re installed mysql odbc driver problem solved

    once again thank you for that

    have agood day
    “There are no failures - just experiences and your reactions to them.”


  •  

    Posting Permissions

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