Share this topic on Del.icio.usShare this topic on DiggShare this topic on FacebookShare this topic on GoogleShare this topic on SlashdotShare this topic on StumbleUponShare this topic on TechnoratiShare this topic on TwitterShare this topic on YahooShare this topic on Google buzz

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

0 Members and 1 Guest are viewing this topic.

Offline ranotea

  • Siswa IF
  • *
  • Posts: 136
  • Reputasi: 9

  • Aktivitas bulan ini
    0%
    • 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: 145
  • Reputasi: 7

  • Aktivitas bulan ini
    0%
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

  • Aktivitas bulan ini
    0%
  • 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: [Select]
http://www.connectionstrings.com/mysql
ato ke
Code: [Select]
http://www.sqlstrings.com/MySQL-connection-strings.htm
salam
.:: Di Atas Langit Masih Ada Langit ::.