总结:Connection大全
1.Sqlserver
A.ODBC
I.Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
II.Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;
Trusted_Connection=yes;"
III.Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
B.OLE DB, OleDbConnection (.NET)
I.Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User
Id=sa;Password=asdasd;"
II.Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;
Integrated Security=SSPI;"
(仅适用于Sqlserver 2000)
III.Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"
IV.Connect via an IP address:
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
C.SqlConnection (.NET)
I.Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
或者"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;
Trusted_Connection=False"
II.Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
或者"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(仅适用于Sqlserver 2000)
III.Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=pubs;User ID=sa;Password=asdasd;"
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)
通过SQLOLEDB provider 连接,用Network Library=dbmssocn,通过MSDASQL
provider连接,用Network=dbmssocn
IV.声明方法:
C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();
VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()
D.Data Shape
MS Data Shape
"Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial
Catalog=pubs;User ID=sa;Password=asdasd;"
呵呵,Data Shape没用过,请参照
http://www.4guysfromrolla.com/webtech/092599-1.shtml
2.Access
A.ODBC
I.Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Uid=Admin;Pwd=;"
II.Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;"
III.Exclusive:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Exclusive=1;Uid=admin;Pwd="
B.OLE DB, OleDbConnection (.NET)
I.Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
User Id=admin;Password=;"
II.Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
Jet OLEDB:System Database=system.mdw;"
III.With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
Jet OLEDB:Database Password=MyDbPassword;"
3.Oracle
A.ODBC
I.New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;
Uid=Username;Pwd=asdasd;"
II.Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=
OracleServer.world;Uid=myUsername;Pwd=myPassword;"
B.OLE DB, OleDbConnection (.NET)
I.Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;
Password=asdasd;"
注:上面是用MS的驱动,下面是用Oracle提供的驱动:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=Username;Password=asdasd;"
II.Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
C.OracleConnection (.NET)
I.Standard:
"Data Source=Oracle8i;Integrated Security=yes";
注:此写法用于Oracle 8i release 3及以上版本。
声明方法:
C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();
VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()
D.Data Shape
I.MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data
Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
3.MySQL
A.ODBC
I.Local database:
"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
II.Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;
Stmt=;Database=my-database;Uid=username;Pwd=password;"
B.OLE DB, OleDbConnection (.NET)
I.Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;
Password=asdasd;"
C.MySqlConnection (.NET)
I.eInfoDesigns.dbProvider:
"Data Source=server;Database=mydb;User ID=username;
Password=pwd;Command Logging=false"
注:此写法仅用于通过eInfoDesigns dbProvider连接:
II.声明方法:
C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();
VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
4.Interbase
A.ODBC (Easysoft ODBC-Interbase driver )
I.Local computer:
"Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:
C:\mydatabase.gdb;Uid=username;Pwd=password"
II.Remote Computer:
"Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName
:C:\mydatabase.gdb;Uid=username;Pwd=password"
B.ODBC (Intersolv ODBC-Interbase driver )
I.Local computer:
"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;
Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password"
II.Remote Computer:
"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};
Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;
Uid=username;Pwd=password"
C.OLE DB (SIBPROvider Driver)
I.Standard:
"provider=sibprovider;location=localhost:;data source=c:
\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey"
II.Specifying character set:
"provider=sibprovider;location=localhost:;data source=c:
\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;
character set=ISO8859_1"
III.Specifying role:
"provider=sibprovider;location=localhost:;data source=c:
\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;
role=DIGITADORES"
6.IBM DB2
A.OLE DB, OleDbConnection (.NET) from ms
I.TCP/IP:
"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network
Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package
Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
II.APPC:
"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU
Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default
Schema=Schema;User ID=MyUser;Password=MyPW"
7.Sybase
A.ODBC
I.Standard Sybase System 12 (or 12.5) Enterprise Open Client:
"Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"
II.Standard Sybase System 11:
"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
III.Intersolv 3.10:
"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;
Pwd=password;"
IIII.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="""""
B.OLEDB
I.Adaptive Server Anywhere (ASA):
"Provider=ASAProv;Data source=myASA"
II.Adaptive Server Enterprise (ASE) with Data Source .IDS file:
"Provider=Sybase ASE OLE DB Provider; Data source=myASE"
注:必须先用Data Administrator创建Data Source .IDS file
III.Adaptive Server Enterprise (ASE):
"Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;
User Id=username;Password=password"
8.Informix
A.ODBC
I.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
II.Informix-CLI 2.5:
"Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;
Uid=username;Pwd=myPwd"
B.OLE DB
I.IBM Informix OLE DB Provider:
"Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=
dbName@serverName;Persist Security Info=true"
9.Mimer SQL
A.ODBC
I.Standard Security:
"Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;"
II. Prompt for username and password:
"Driver={MIMER};Database=mydb;"
10.DSN
A.ODBC
I.DSN:
"DSN=myDsn;Uid=username;Pwd=;"
II.File DSN:
"FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"
11.Excel
A.ODBC
I.Standard:
"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;
Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"
B.OLE DB
I.Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data.
"IMEX=1;" tells the driver to always read "intermixed" data columns as text.
12.Text
A.ODBC
I.Standard:
"Driver={Microsoft Text Driver (*.txt; *.csv)};
Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;"
B.OLE DB
I.Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended
Properties=""text;HDR=Yes;FMT=Delimited"""
"HDR=Yes;" indicates that the first row contains columnnames, not data.
13.DBF / FoxPro
A.ODBC
I.standard:
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
B.OLE DB, OleDbConnection (.NET)
I.standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=
dBASE IV;User ID=Admin;Password="
14.Visual FoxPro
A.OLE DB, OleDbConnection (.NET)
I.Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;
Password=MyPassWord;Collating Sequence=machine"
II. Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Password=MyPassWord;
Collating Sequence=general"
B.ODBC
I.Database container (.DBC):
"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=
c:\myvfpdb.dbc;Exclusive=No;Collate=Machine;"
II.Free Table directory:
"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=
c:\myvfpdbfolder;Exclusive=No;Collate=Machine;"
15.Pervasive (没听说过这个东东)
A.ODBC
I.Standard:
"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
B.OLE DB
I.Standard:
"Provider=PervasiveOLEDB;Data Source=C:\path"
16.UDL
"File Name=c:\myDataLink.udl;"