OleDbConnection string : OleDbConnection « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbConnection

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); 
        }
    }
}

 

Related examples in the same category