ADO.NET DB연결 문자열 - System.Data.SqlClient

SQL Server .NET Data Provider
 System.Data.SqlClient

Using C#:

using System.Data.SqlClient;
...
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Data Source=(local);" +
                            "Initial Catalog=myDatabaseName;" +
                            "Integrated Security=SSPI";
oSQLConn.Open();


Using VB.NET:

Imports System.Data.SqlClient
...
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString = "Data Source=(local);" & _
                            "Initial Catalog=myDatabaseName;" & _
                            "Integrated Security=SSPI"
oSQLConn.Open()


원격서버 IP 연결:

oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _
                            "Data Source=◯.◯.◯.◯,1433;" & _
                            "Initial Catalog=myDatabaseName;" & _
                            "User ID=myUsername;" & _
                            "Pas sword=myPassword"


* TCP/IP 연결시, Network Library=DBMSSOCN. 암호화시 Encrypt=yes


연결시 선택가능한 네트워크 프로토콜:

         Name                       Network library 
         dbnmpntw               Win32 Named Pipes *
         dbmssocn               Win32 Winsock TCP/IP *
         dbmsspxn               Win32 SPX/IPX 
         dbmsvinn                Win32 Banyan Vines 
         dbmsrpcn               Win32 Multi-Protocol (Windows RPC) * 


좀더 자세한 사항은 MSDN 을 참조하세요.
1. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefsqlprovspec.asp

2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoproperties.asp

ADO.NET DB연결 문자열 - Oracle.DataAccess.Client

Oracle .NET Data Provider - From Oracle
 Oracle.DataAccess.Client

using Oracle.DataAccess.Client;
...
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" +
                               "Integrated Security=SSPI";
oOracleConn.Open();

* 오라클에서 제공하는 드라이버를 이용하는 경우입니다.
[오라클 제공 닷넷 드라이버 다운로드]

ADO.NET DB연결 문자열 - System.Data.OracleClient

Oracle .NET Data Provider - From Microsoft
 System.Data.OracleClient

using System.Data.OracleClient;
 
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
                               "Integrated Security=SSPI";
oOracleConn.Open();


*오라클 클라이언트가 최소한 8.1.7 이상은 설치되어야 합니다.