分享
 
 
 

总结:Connection大全

王朝other·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有