|
'****************************
Imports System.Data.Odbc '**************************** ' Casa = "Data Source=GENIO\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=True" "Data Source=GENIO\SQLEXPRESS;Initial Catalog=nORTHwIND;Integrated Security=True" String MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=test;" + "UID=venu;" + "PASSWORD=venu;" + "OPTION=3"; OdbcConnection MyConnection = New OdbcConnection(MyConString); MyConnection.Open(); MySqlConnection the main connection to the MySQL database MySqlCommand enables the execution of any command against the database. MySqlDataReader provides fast, forward-only read access to the database. MySqlDataAdapter serves as an interface between the MySQL data classes and the Microsoft DataSet. MySqlParameter used to store dynamic parameters for a command. MySqlTransaction used to represent a MySQL transaction. DNS OdbcConnection MyConnection = New OdbcConnection("DSN=myodbc3-test"); MyConnection.Open(); MyODBC MyODBC 2.50 Local database Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase; MyODBC 2.50 Remote database Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword; 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=myUsername;Password=myPassword; COPY TO CLIPBOARD Connector/Net 1.0 (.NET) Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword; MySqlConnection (.NET) Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false; Standard Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase; Core Labs MySQLDirect (.NET) Standard User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0; MySQLDriverCS (.NET) Standard Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties=""""; |