C#資料庫連接字串——Sybase

1. ODBC DSN
2. ODBC -- Sybase System 12 (12.5) ODBC Driver
3. ODBC -- Sybase System 11 ODBC Driver
4. ODBC -- Intersolv 3.10 ODBC Driver
5. ODBC -- SQL Anywhere
6. OleDb -- Sybase Adaptive Server Enterprise (ASE)
7. .NET DataProvider from Sybase

 

 

  
// ODBC DSN    
  
 
  
using System.Data.Odbc;  
  
 
  
OdbcConnection conn = new OdbcConnection();  
  
conn.ConnectionString =   
  
              "Dsn=DsnName;" +   
  
              "Uid=UserName;" +   
  
              "Pwd=Secret;";   
  
conn.Open();   
 

 

  
// ODBC -- Sybase System 12 (12.5) ODBC Driver    
  
 
  
using System.Data.Odbc;  
  
 
  
OdbcConnection conn = new OdbcConnection();  
  
conn.ConnectionString =   
  
              "Driver={SYBASE ASE ODBC Driver};" +   
  
              "Srvr=ServerName;" +   
  
              "Uid=UserName;" +   
  
              "Pwd=Secret;";   
  
conn.Open();   
 

 

  
// ODBC -- Sybase System 11 ODBC Driver    
  
 
  
using System.Data.Odbc;  
  
 
  
OdbcConnection conn = new OdbcConnection();  
  
conn.ConnectionString =   
  
           "Driver={SYBASE SYSTEM 11};" +   
  
           "Srvr=ServerName;" +   
  
           "Uid=UserName;" +   
  
           "Pwd=Secret;";   
  
conn.Open();  
  
   
 

 

  
// ODBC -- Intersolv 3.10 ODBC Driver    
  
 
  
using System.Data.Odbc;  
  
 
  
OdbcConnection conn = new OdbcConnection();  
  
conn.ConnectionString =   
  
        "Driver={INTERSOLV 3.10 32-BIT Sybase};" +   
  
        "Srvr=ServerName;" +   
  
        "Uid=UserName;" +   
  
        "Pwd=Secret;";   
  
conn.Open();   
 

 

  
// ODBC -- SQL Anywhere    
  
 
  
using System.Data.Odbc;  
  
 
  
OdbcConnection conn = new OdbcConnection();  
  
conn.ConnectionString =   
  
         "ODBC;" +   
  
         "Driver={Sybase SQL Anywhere 5.0};" +   
  
         "DefaultDir=c:\myfolder\;" +   
  
         "Dbf=c:\mypath\dbname.db;" +   
  
         "Uid=UserName;" +   
  
         "Pwd=Secret;" +   
  
         "Dsn="""";";     // Must be included!  
  
conn.Open();   
 

 

  
// OleDb -- Sybase Adaptive Server Enterprise (ASE)    
  
 
  
using System.Data.OleDb;  
  
 
  
OleDbConnection conn = new OleDbConnection();  
  
conn.ConnectionString =   
  
              "Driver=Sybase.ASEOLEDBProvider;" +   
  
              "Server Name=ServerName,5000;" +   
  
              "Initial Catalog=DataBaseName;" +   
  
              "User id=UserName;" +   
  
              "Password=Secret;";   
  
conn.Open();  
  
 
  
// optionally, replace   
  
// 'Server Name' with 'Srvr', and   
  
// 'Initial Catalog' with 'Catalog'  
  
   
 

 

  
// .NET DataProvider from Sybase    
  
 
  
using Sybase.Data.AseClient;  
  
 
  
AseConnection conn = new AseConnection();  
  
conn.ConnectionString =   
  
              "Data Source=ServerName;" +   
  
              "Initial Catalog=DataBaseName;" +   
  
              "User id=UserName;" +   
  
              "Password=Secret;";   
  
conn.Open();