| 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=;" |