각 DB별 ConnectionString 정리

 1. MS SQL Server

 2. MS Access

 3. Oracle

 4. MySql

 

=================================

 

   [ Microsoft SQL Server  ]

// ODBC DSN  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Dsn=DsnName;" + 
              "Uid=UserName;" + 
              "Pwd=Secret;"; 
conn.Open();



// ODBC -- Standard Connection  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Driver={SQL Server};" + 
              "Server=ServerName;" + 
              "DataBase=DataBaseName;" + 
              "Uid=UserName;" + 
              "Pwd=Secret;"; 
conn.Open();



// ODBC -- Trusted Connection  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Driver={SQL Server};" + 
              "Server=ServerName;" + 
              "DataBase=DataBaseName;" + 
              "Uid=;" + 
              "Pwd=;"; 
conn.Open();

// or

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Driver={SQL Server};" + 
              "Server=ServerName;" + 
              "DataBase=DataBaseName;" + 
              "Trusted_Connection=Yes;"; 
conn.Open();



// OleDb -- Standard Connection  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=SQLOLEDB;" + 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();



// OleDb -- Trusted Connection  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=SQLOLEDB;" + 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "Integrated Security=SSPI;"; 
conn.Open();



// OleDb -- via IP Address  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=SQLOLEDB;" + 
              "Network Library=DBMSSOCN;" + 
              "Data Source=xxx.xxx.xxx.xxx,1433;" + 
              "Initial Catalog=DataBaseName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();



// .NET DataProvider -- Standard Connection  

using System.Data.SqlClient;

SqlConnection conn = new SqlDbConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();



// .NET DataProvider -- Trusted Connection  

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "Integrated Security=SSPI;"; 
conn.Open();



// .NET DataProvider -- via IP Address  

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();
conn.ConnectionString = 
              "Network Library=DBMSSOCN;" + 
              "Data Source=xxx.xxx.xxx.xxx,1433;" + 
              "Initial Catalog=DataBaseName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();


========================================

      [    Microsoft Access    ]

// ODBC DSN  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Dsn=DsnName";
conn.Open();



// ODBC -- Standard Security  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
    "Driver={Microsoft Access Driver (*.mdb)};" + 
    "Dbq=c:\myPath\myDb.mdb;" + 
    "Uid=Admin;Pwd=;"; 
conn.Open();



// ODBC -- Workgroup (System Database)  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
    "Driver={Microsoft Access Driver (*.mdb)};" + 
    "Dbq=c:\myPath\myDb.mdb;" + 
    "SystemDb=c:\myPath\myDb.mdw;"; 
conn.Open();



// ODBC -- Exclusive Use  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
     "Driver={Microsoft Access Driver (*.mdb)};" + 
     "Dbq=c:\myPath\myDb.mdb;" + 
     "Exclusive=1;"; 
     "Uid=Admin;Pwd=;"; 
conn.Open();



// OleDb with MS Jet -- Standard Security  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
           "Provider=Microsoft.Jet.OLEDB.4.0;" + 
           "Data Source=c:\mypath\myDb.mdb;" + 
           "User Id=admin;" + 
           "Password=";
conn.Open();



// OleDb with MS Jet -- Workgroup (System Database)  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
           "Provider=Microsoft.Jet.OLEDB.4.0;" + 
           "Data Source=c:\mypath\myDb.mdb;" + 
           "System Database=c:\mypath\myDb.mdw;"; 
conn.Open();



// OleDb with MS Jet -- With Password  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
           "Provider=Microsoft.Jet.OLEDB.4.0;" + 
           "Data Source=c:\mypath\myDb.mdb;" + 
           "Database Password=Secret;"
conn.Open();



====================================

           [    Oracle   ]

// ODBC DSN  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Dsn=DsnName;" + 
              "Uid=UserName;" + 
              "Pwd=Secret;"; 
conn.Open();



// ODBC -- New Microsoft Driver  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
           "Driver={Microsoft ODBC for Oracle};" + 
           "Server=OracleServer.world;" + 
           "Uid=UserName;" + 
           "Pwd=Secret;"; 
conn.Open();



// ODBC -- Old Microsoft Driver  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
    "Driver={Microsoft ODBC Driver for Oracle};" + 
    "ConnectString=OracleServer.world;" + 
    "Uid=UserName;" + 
    "Pwd=Secret;"; 
conn.Open();



// ODBC -- Oracle Driver  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
    "Driver={Oracle ODBC Driver};" + 
    "Dbq=myDataBase;" + // define in tsnames.ora
    "Uid=UserName;" + 
    "Pwd=Secret;"; 
conn.Open();



// OleDb -- Microsoft Driver  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=MSDAORA;" + 
              "Data Source=ServerName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();



// OleDb -- Oracle Driver -- Standard Connection  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=OraOLEDB.Oracle;" + 
              "Data Source=ServerName;" + 
              "User Id=UserName;" + 
              "Password=Secret;"; 
conn.Open();



// OleDb -- Oracle Driver -- Trusted Connection  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=OraOLEDB.Oracle;" + 
              "Data Source=ServerName;" + 
              "OSAuthent=1;";
conn.Open();

// or 

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
              "Driver=OraOLEDB.Oracle;" + 
              "Data Source=ServerName;" + 
              "User Id=/" + 
              "Password=;"; 
conn.Open();



// .NET DataProvider from Microsoft 
// -- Standard Connection 


using System.Data.OracleClient;

OracleConnection conn = new OracleConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "User Id=UserName;"; 
              "Password=Secret;"; 
conn.Open();



// .NET DataProvider from Microsoft 
// -- Trusted Connection 


using System.Data.OracleClient;

OracleConnection conn = new OracleConnection();
conn.ConnectionString = 
              "Data Source=Servername;" + 
              "Integrated Security=Yes;"; 
conn.Open();



// .NET DataProvider from Oracle 
// -- Standard Connection 


using Oracle.DataAccess.Client;

OracleConnection conn = new OracleConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "User Id=UserName;"; 
              "Password=Secret;"; 
conn.Open();





// .NET DataProvider from Oracle 
// -- Trusted Connection 


using Oracle.DataAccess.Client;

OracleConnection conn = new OracleConnection();
conn.ConnectionString = 
              "Data Source=Servername;" + 
              "Integrated Security=Yes;"; 
conn.Open();

========================================================

               [          MySql          ]

// ODBC DSN  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
              "Dsn=DsnName;" + 
              "Uid=UserName;" + 
              "Pwd=Secret;"; 
conn.Open();



// ODBC -- MyODBC Driver -- local database  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
            "Driver={MySql};" + 
            "Server=localhost;" + 
            "Option=16834;" + 
            "DataBase=DataBaseName;" 
conn.Open();



// ODBC -- MyODBC Driver -- remote database  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
            "Driver={MySql};" + 
            "Server=db.domain.com;" + 
            "Option=131072;" + 
            "Port=3306;" + 
            "Stmt=;" + 
            "DataBase=DataBaseName;" + 
            "Uid=UserName;" + 
            "Pwd=Secret;" 
conn.Open();



// ODBC -- MySQL ODBC 3.51 Driver  

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
     "Driver={MySql ODBC 3.51 Driver};" + 
     "Server=ServerName;" + 
     "Option=16834;" + 
     "Port=3306;" + 
     "Stmt=;" + 
     "DataBase=DataBaseName;" + 
     "Uid=UserName;" + 
     "Pwd=Secret;" 
conn.Open();

// or 

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = 
     "DRIVER={MySql ODBC 3.51 Driver};" + 
     "SERVER=ServerName;" + 
     "DATABASE=DataBaseName;" + 
     "USER=UrerName;" + 
     "PASSWORD=Secret;" 
conn.Open();



// OleDb  

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = 
            "Provider=MySqlProv;" + 
            "Data Source=ServerName;" + 
            "User Id=UserName;" + 
            "Password=Secret;" 
conn.Open();


// .NET DataProvider from CoreLab 


using CoreLab.MySql;

MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = 
              "Host=ServerName;" + 
              "DataBase=DataBaseName;" + 
              "Protocol=TCP;" + 
              "Port=3306;" + 
              "Direct=true;" + 
              "Compress=false;" + 
              "Pooling=true;" + 
              "Min Pool Size=0;" + 
              "Max Pool Size=100;" + 
              "Connection Lifetime=0;" + 
              "User Id=UserName;" + 
              "Password=Secret;" + 
conn.Open();