Type: .NET Framework Class Library
Usage: MySql.Data.MySqlClient.MySqlConnection
Manufacturer: MySQL
Standard - Default port is 3306
Specifying portCode:Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Named pipesCode:Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Multiple ServerCode:Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Using encryptionCode:Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
orCode:Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true;
Sample CodeCode:Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encrypt=true;
Code:Imports MySql.Data.MySqlClient ' database Private mySqlConnection As New MySqlConnection Private myAdaptor As New MySqlDataAdapter Private command As New MySqlCommand 'connection - FINISHED Public Sub MyySQLConnection() Try mySqlConnection.ConnectionString = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" command.Connection = mySqlConnection myAdaptor.SelectCommand = command mySqlConnection.Open() Catch ex As MySqlException MessageBoxEx.Show("No Remote or Local MySQL server connection." & Environment.NewLine & ex.Message, "Offline!", MessageBoxButtons.OK, MessageBoxIcon.Information) Finally mySqlConnection.Dispose() mySqlConnection.Close() End Try End Sub
















Reply With Quote




