[C#] DB연결 / Connection String 정리

다양한 DB와의 연결 구분자를 정리하였습니다. 

많은 도움이 되길 바랍니다. 

 

1. SQL Server
ODBC
Driver={SQL Server};Server=myServerAddress;Database=DBName;Uid=myUsername;Pwd=myPassword;
OLE DB  
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=DBName;User Id=myUsername;Password=myPassword; 
 
2. SQL Server 2005
ODBC
Driver={SQL Native Client};Server=myServerAddress;Database=DBName;Uid=myUsername;Pwd=myPassword;
OLE DB    
Provider=SQLNCLI;Server=myServerAddress;Database=DBName;Uid=myUsername;Pwd=myPassword;

3. Firebird
ODBC
Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;DbName=D:\work\examples\TEST.FDB;

4. Oracle
ODBC  
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword; 
OLE DB
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

5. MySQL
MyODBC 2.50 Remote database
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;Database=DBName;Uid=myUsername;Pwd=myPassword; 
MyODBC 3.51
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=DBName;User=myUsername;Password=myPassword;Option=3;  
OLE DB
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

6. Postgre SQL
ODBC   
Driver={PostgreSQL};Server=IP address;Port=5432;Database=DBName;Uid=myUsername;Pwd=myPassword;  
OLE DB
Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=DBName;User ID=myUsername;password=myPassword;timeout=1000;

7. SQLite
ODBC
DRIVER=SQLite3 ODBC Driver;Database=mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;  
DSN
DSN=myDsn;Uid=myUsername;Pwd=;
File DSN
FILEDSN=c:\myData.dsn;Uid=myUsername;Pwd=;
UDL 
File Name=c:\myDataLink.udl;  

8. Excel 97 ~ 2003
OLE DB
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;HDR=YES

9. Excel 2007
OLE DB
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\work\myExcel2007file.xlsx;Extended Properties=Excel 12.0;HDR=YES";
String conStr = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""", filePath);

10. Access 2003
OLE DB
@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\TestData\test.mdb";
OLE DB with password
String conStr = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; Jet OLEDB:Database Password={1};", filePath, dbPass);

11. Access 2007
OLE DB
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\work\myAccess2007file.accdb;Persist Security Info=False; 
OLE DB with password
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\work\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword; 
 
Text File
ODBC   
Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;