Forum Informatika

      MyODBC
      MyODBC 2.50 Local database:
      "Driver={mySQL};Server=localhost;
      Option=16834;Database=mydatabase;"

      MyODBC 2.50 Remote database:
      "Driver={mySQL};Server=data.domain.com;
      Port=3306;Option=131072;Stmt=;
      Database=my-database;Uid=username;Pwd=password;"

      MyODBC 3.51 Local database:
      "DRIVER={MySQL ODBC 3.51 Driver};
      SERVER=localhost;DATABASE=myDatabase;
      USER=myUsername;
      PASSWORD=myPassword;OPTION=3;"

      MyODBC 3.51 Remote database:
      "DRIVER={MySQL ODBC 3.51 Driver};
      SERVER=data.domain.com;
      PORT=3306;DATABASE=myDatabase;
      USER=myUsername;PASSWORD=myPassword;OPTION=3;"

      OLE DB, OleDbConnection (.NET)     
      Standard:
      "Provider=MySQLProv;Data Source=mydb;
      User Id=UserName;Password=asdasd;"
      Connector/Net 1.0 (.NET)

      Standard:
      "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"

      Download the driver at MySQL Developer Zone.

      Specifying port:
      "Server=Server;Port=1234;Database=Test;
      Uid=UserName;Pwd=asdasd;"

      Default port is 3306. Enter value -1 to use a named pipe connection.

      Declare the MySqlClient connection:
      VB.NET:
      Imports MySql.Data.MySqlClient
      Dim MySqlConn As MySqlConnection = New MySqlConnection()
      MySqlConn.ConnectionString
      = "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"
      MySqlConn.Open()

      MySqlConnection (.NET)
      eInfoDesigns.dbProvider:
      "Data Source=server;Database=mydb;User
      ID=username;Password=pwd;Command Logging=false"
      This one is used with eInfoDesigns dbProvider, an add-on to .NET

      Declare the MySqlConnection:
      VB.NET:
      Imports eInfoDesigns.dbProvider.MySqlClient
      Dim oMySqlConn As MySqlConnection = New MySqlConnection()
      MySqlConn.ConnectionString = "my connection string"
      MySqlConn.Open()

    * SevenObjects MySqlClient (.NET)
      Standard:
      "Host=server; UserName=myusername; Password=mypassword;Database=mydb;"

      This is a freeware ADO.Net data provider from SevenObjects

    * Core Labs MySQLDirect (.NET)
      Standard:
      "User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;
      Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;
      Max Pool Size=100; Connection Lifetime=0"