DB Connection String Access DB2 AS400 DBase Excel Exchange Firebird FoxPro Informix MySQL Oracle SQL Server Sybase
Access
|
Driver Type |
Connection |
|
ODBC |
{Microsoft Access Driver (*.mdb)};Dbq=C:\demo.mdb;Uid=Admin;Pwd=; |
|
OLEDB |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\directory\demo.mdb;User Id=admin;Password=; |
DB2
|
Driver Type |
Connection |
|
ODBC |
driver={IBM DB2 ODBC DRIVER};Database=demodb;hostname=myservername;port=myPortNum;protocol=TCPIP; uid=myusername; pwd=mypasswd |
|
OLEDB |
Provider=IBMDADB2;Database=demodeb;HOSTNAME=myservername;PROTOCOL=TCPIP;PORT=50000;uid=myusername;pwd=mypasswd; |
AS/400
|
Driver Type |
Connection |
|
ODBC |
Driver = {iSeries Access ODBC Driver} ; System=IP位置; Uid=帳號; Pwd=密碼; |
|
OLEDB |
Provider = IBMDA400;Data Source = IP位置; User Id = 帳號; Password = 密碼; Default Collection = 預設目錄; |
DBase
|
Driver Type |
Connection |
|
ODBC |
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\directory; |
|
OLEDB |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\directory;Extended Properties=dBASE IV;User ID=Admin;Password= |
Excel
|
Driver Type |
Connection |
|
ODBC |
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory; |
|
OLEDB |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties='"Excel 8.0;HDR=Yes;IMEX=1"' |
Exchange
|
Driver Type |
Connection |
|
OLEDB |
oConn.Provider = "EXOLEDB.DataSource" oConn.Open = "http://myServerName/myVirtualRootName" |
Firebird
|
Driver Type |
Connection |
|
ODBC |
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=mypasswd;DBNAME=c:\directory\demo.fdb |
|
OLEDB |
User=SYSDBA;Password=mypasswd;Database=demo.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0 |
FoxPro
|
Driver Type |
Connection |
|
ODBC |
Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO |
|
OLEDB |
Provider=vfpoledb.1;Data Source=c:\directory\demo.dbc;Collating Sequence=machine |
Informix
|
Driver Type |
Connection |
|
ODBC |
Driver={Informix-CLI 2.5 (32 Bit)};Server=demoservername;Database=demodb;Uid=myusername;Pwd=mypasswd |
|
OLEDB |
Provider=Ifxoledbc.2;User ID=myusername;password=mypasswd;Data Source=demodb@demoservername;Persist Security Info=true |
MySQL
|
Driver Type |
Connection |
|
ODBC |
DRIVER={MySQL ODBC 3.51 Driver};SERVER=myservername;PORT=3306;DATABASE=mydemodb; USER=myusername;PASSWORD=mypasswd;OPTION=3; |
|
OLEDB |
Provider=MySQLProv;Data Source=mydemodb;User Id=myusername;Password=mypasswd; |
Oracle
|
Driver Type |
Connection |
|
ODBC |
Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword; |
|
OLEDB |
Provider=msdaora;Data Source=mydemodb;User Id=myusername;Password=mypasswd; |
|
.Net |
Data Source=mydemodb;User Id=myusername;Password=mypasswd;Integrated Security=no; |
SQL Server
|
Driver Type |
Connection |
|
ODBC - Database Login |
Driver={SQL Server};Server=myservername;Database=mydemodb;Uid=myusername;Pwd=mypasswd; |
|
ODBC - Trusted Connection |
Driver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes; |
|
OLEDB - Database Login |
Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd; |
|
OLEDB - Trusted Connection |
Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI; |
|
.Net - Database Login |
Server=myservername;Database=mydemodb;User ID=myusername;Password=mypasswd;Trusted_Connection=False |
|
.Net - Trusted Connection |
Server=myservername;Database=mydemodb;Integrated Security=SSPI; |
Sybase
|
Driver Type |
Connection |
|
ODBC |
Driver={SYBASE ASE ODBC Driver};Srvr=myservername;Uid=myusername;Pwd=mypasswd |
|
OLEDB |
Provider=Sybase.ASEOLEDBProvider;Server Name=myservername,5000;Initial Catalog=mydemodb;User Id=myusername;Password=mypassword |