Mega Code Archive

 

Categories / C# / ADO Database

 

OleDbConnection string

using System; using System.Diagnostics; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; public class MainClass {     static void Main() {         try {             OleDbConnection cnOleDb = new OleDbConnection("Provider=SQLOLEDB.1;Password=pw;Persist Security Info=False;User ID=admin;Initial Catalog=biblio;Data Source=betav9;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BETAV9;Use Encryption for Data=False;Tag with column collation when possible=False");             cnOleDb.Open();         } catch (OleDbException exOleDb) {             MessageBox.Show(exOleDb.Message);         } catch (Exception ex) {             MessageBox.Show(ex.Message);          }     } }