Announcement

Collapse
No announcement yet.

MySQL ConnectionString.....HELP!!!!!!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL ConnectionString.....HELP!!!!!!

    I've just moved over to the hosting here and am in the process of moving my sites accross.
    all was going well until i try to connect to the database.
    I can connect vie MySQL Query Browser and add all of my tables and data, but as soon as i try to connect from my code (classic asp) i get an error.

    I was using the following connection string:

    Driver={mySQL};Server=[IP Address of server];Stmt=;Database=[DATABASE NAME];Uid=[USER];Pwd=[PASSWORD];

    but i get the following error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /testimonial.asp, line 13


    Can anyone point me in the right direction please?
    I need to get this sorted quickly as downtime is a problem.

    Thanks

  • #2
    Hi Ian,

    I've corrected the connection string in your code, please check the site now. You might want to restore the MySQL database such that the other errors can be fixed too

    Driver={MySQL ODBC 5.1 Driver};Server=[IP ADDRESS];Database=[DATABASE NAME];User=[USER];Password=[PASSWORD];

    More info on MySQL connection strings can be found here : MySQL Connection String Samples - ConnectionStrings.com

    Please get in touch if you require any further assistance, good luck !
    Kind regards,
    Jack Daniel.

    Cloud Hosting || Managed Dedicated Server || Webhosting UK Knowledgebase

    Comment


    • #3
      Thats great thanks.
      I'd tried several different combinations (including ones suggested on the siteyou mentioned)
      and it turns out to be the name of the driver i had got wrong. lol

      Oh well. it works now.

      Thanks again for the help, its much appreciated.

      Comment


      • #4
        Originally posted by gimbal View Post
        Thats great thanks.
        I'd tried several different combinations (including ones suggested on the siteyou mentioned)
        and it turns out to be the name of the driver i had got wrong. lol

        Oh well. it works now.

        Thanks again for the help, its much appreciated.
        You're welcome
        Kind regards,
        Jack Daniel.

        Cloud Hosting || Managed Dedicated Server || Webhosting UK Knowledgebase

        Comment

        Working...
        X