RSS

MySQL connection strings

Tue, Aug 12, 2008

Connection Strings

MySQL ODBC connection strings

Open connection to local MySQL database using MySQL ODBC 3.51 Driver
“Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3″

MySQL OLE DB & OleDbConnection (.NET framework) connection strings

Open connection to MySQL database:
“Provider=MySQLProv;Data Source=Your_MySQL_Database;User Id=Your_Username; Password=Your_Password;”

, , , , ,

4 Comments For This Post

  1. mars Says:
    September 25th, 2008 at 9:16 am

    Sir pano naman po ung connection through php and mysql sa windows hosting, marami na kasi ako natry pro laging access denied

  2. Mike Says:
    October 4th, 2008 at 11:08 am

    Hei! Try creating a comment using English language.. (hndi agad massagot tanong mo)

  3. Me Says:
    November 24th, 2008 at 10:09 am

    what is the best to edit my sql server database

  4. Allan Says:
    December 10th, 2008 at 4:25 pm

    For web browser, phpmyadmin is the best… but for windows client… I prefer SQLyog. It make my life easier.

    :)

Leave a Reply