| Sybase |
| ODBC |
| 标准 Sybase System 12 (or 12.5) Enterprise Open Client | "Driver={SYBASE ASE ODBC Driver}; Srvr=Aron1; Uid=username; Pwd=password" |
| 标准 Sybase System 11 | "Driver={SYBASE SYSTEM 11}; Srvr=Aron1; Uid=username; Pwd=password; Database=mydb" |
| Intersolv 3.10 | "Driver={INTERSOLV 3.10 32-BIT Sybase}; Srvr=Aron1; Uid=username; Pwd=password;" |
| Sybase SQL Anywhere (former Watcom SQL ODBC driver) | "ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\; Dbf=c:\mydatabase.db; Uid=username; Pwd=password; Dsn=""""" |
| OLE DB |
| Adaptive Server Anywhere (ASA) | "Provider=ASAProv; Data source=myASA" |
| Adaptive Server Enterprise (ASE) with Data Source .IDS file | "Provider=Sybase ASE OLE DB Provider; Data source=myASE" |
| Adaptive Server Enterprise (ASE) | "Provider=Sybase.ASEOLEDBProvider; Srvr=myASEserver,5000; Catalog=myDBname; User Id=username; Password=password"
- some reports on problem using the above one, try the following as an alternative - "Provider=Sybase.ASEOLEDBProvider; Server Name=myASEserver,5000; Initial Catalog=myDBname; User Id=username; Password=password"
This one works only from Open Client 12.5 where the server port number feature works,following fully qualified connection strings to be used without definingfony .IDS Data Source files. |
| AseConnection (.NET) |
| 标准 | "Data Source='myASEserver'; Port=5000; Database='myDBname'; UID='username'; PWD='password'; " |
| 定义AseConnection连接对象 | C#:
using Sybase.Data.AseClient;
AseConnection oCon = new AseConnection();
oCon.ConnectionString="my connection string";
oCon.Open(); |
VB.NET:
Imports System.Data.AseClient
Dim oCon As AseConnection = New AseConnection()
oCon.ConnectionString="my connection string"
oCon.Open() |
| |
| Informix |
| ODBC |
| Informix 3.30 | "Dsn=''; Driver={INFORMIX 3.30 32 BIT}; Host=hostname; Server=myserver; Service=service-name; Protocol=olsoctcp; Database=mydb; UID=username; PWD=myPwd" |
| Informix-CLI 2.5 | "Driver={Informix-CLI 2.5 (32 Bit)}; Server=myserver; Database=mydb; Uid=username; Pwd=myPwd" |
| OLE DB |
| IBM Informix OLE DB Provider | "Provider=Ifxoledbc.2; password=myPw; User ID=myUser; Data Source=dbName@serverName; Persist Security Info=true" |
| |
| Ingres |
| ODBC |
| DSN-less | "Provider=MSDASQL.1; DRIVER=Ingres; SRVR=xxxxx; DB=xxxxx; Persist Security Info=False; uid=xxxx; pwd=xxxxx; SELECTLOOPS=N; Extended Properties="""SERVER=xxxxx; DATABASE=xxxxx; SERVERTYPE=INGRES"" |
| |
| Mimer SQL |
| ODBC |
| 标准安全 | "Driver={MIMER}; Database=mydb; Uid=myuser; Pwd=mypw; " |
| 提示输入用户名和密码 | "Driver={MIMER}; Database=mydb;" |
| |
| Lightbase |
| 标准 |
| 标准 | "user=USERLOGIN; password=PASSWORD; UDB=USERBASE; server=SERVERNAME" |
| |
| PostgreSQL |
| Core Labs PostgreSQLDirect (.NET) |
| 标准 | "User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0" |
| PostgreSQL driver |
| 标准 | "DRIVER={PostgreSQL}; SERVER=ipaddress; port=5432; DATABASE=dbname; UID=username; PWD=password; " |
| Npgsql by pgFoundry (.NET) |
| SSL activated | "Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=true; Pooling=true; MinPoolSize=3; MaxPoolSize=20; Encoding=UNICODE; Timeout=20; SslMode=Require" |
| Without SSL | "Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable" |
| |
| Paradox |
| ODBC |
| 5.X | "Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 5.X; DefaultDir=c:\pathToDb\; Dbq=c:\pathToDb\; CollatingSequence=ASCII" |
| 7.X | "Provider=MSDASQL.1; Persist Security Info=False; Mode=Read; Extended Properties='DSN=Paradox; DBQ=C:\myDb; DefaultDir=C:\myDb; DriverId=538; FIL=Paradox 7.X; MaxBufferSize=2048; PageTimeout=600; '; Initial Catalog=C:\myDb" |
| OleDbConnection (.NET) |
| 标准 | "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\myDb; Extended Properties=Paradox 5.x;" |
| |
| DNS |
| ODBC |
| DSN | "DSN=myDsn; Uid=username; Pwd=; " |
| File DSN | "FILEDSN=c:\myData.dsn; Uid=username; Pwd=;" |
