Author Topic: vb connectionstring to mySQL  (Read 5467 times)

0 Members and 1 Guest are viewing this topic.

Offline ranotea

  • Siswa IF
  • *
  • Posts: 137
  • Reputasi: 9
    • Ranotea's Weblog
  • Lokasi: Bandung
vb connectionstring to mySQL
« on: 22 April 2008, 02:42:23 »
      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"

Forum Informatika

vb connectionstring to mySQL
« on: 22 April 2008, 02:42:23 »
Sponsored Links:


Offline semperfidelis

  • Siswa IF
  • *
  • Posts: 150
  • Reputasi: 7
Re: vb connectionstring to mySQL
« Reply #1 on: 06 November 2009, 23:14:06 »
ini buat scriptnya ato gmn ni, sorry gk mudeng soalnya baru mau blajar buat ngonekiiny?klo blh tambah pertanyaan, klo VB 2008 buat konek ke mysql nya susah gk dan perbedaaan dgn vb 6 apa y?tq

Offline Pocan

  • Newbie
  • *
  • Posts: 8
  • Reputasi: 1
  • AntiTrust = Trust No One
  • Lokasi: Makassar, Celebes Kidul
  • Jenis Kelamin: Laki-laki
Re: vb connectionstring to mySQL
« Reply #2 on: 28 July 2010, 11:59:32 »
coba masuk ke
Code:
Hanya pengunjung TERDAFTAR yang bisa melihat konten. Silakan melakukan Registrasi terlebih dahulu atau Login.
ato ke
Code:
Hanya pengunjung TERDAFTAR yang bisa melihat konten. Silakan melakukan Registrasi terlebih dahulu atau Login.
salam