各种数据源的ConnectString【转】
来源:互联网 发布:江宁人才网最新域名 编辑:程序博客网 时间:2024/06/07 02:37
[转]各种数据源的ConnectString一览:
Table of Connection Strings
DBConnection StringAccessAccess ODBC Connection String Driver{Microsoft Access Driver (*.mdb)};Dbq=C:/demo.mdb;Uid=Admin;Pwd=;Access OLEDB Connection String DriverProvider=Microsoft.Jet.OLEDB.4.0;Data Source=/directory/demo.mdb;User Id=admin;Password=;DB2DB2 ODBC Connection Stringdriver={IBM DB2 ODBC DRIVER};Database=demodb;hostname=myservername;port=myPortNum;protocol=TCPIP; uid=myusername; pwd=mypasswdDB2 OLEDB Connection StringProvider=IBMDADB2;Database=demodeb;HOSTNAME=myservername;PROTOCOL=TCPIP;PORT=50000;uid=myusername;pwd=mypasswd;DBaseDBase ODBC Connection StringDriver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:/directory;DBase OLEDB Connection StringProvider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/directory;Extended Properties=dBASE IV;User ID=Admin;Password=ExcelExcel ODBC Connection StringDriver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:/MyExcel.xls;DefaultDir=c:/directory;Excel OLEDB Connection StringProvider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyExcel.xls;Extended Properties='"Excel 8.0;HDR=Yes;IMEX=1"'ExchangeExchange OLEDB Connection StringoConn.Provider = "EXOLEDB.DataSource" oConn.Open = "http://myServerName/myVirtualRootName"FirebirdFirebird ODBC Connection StringDRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=mypasswd;DBNAME=c:/directory/demo.fdbFirebird OLEDB Connection StringUser=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=0FoxProFoxPro ODBC Connection StringDriver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:/demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NOFoxPro OLEDB Connection StringProvider=vfpoledb.1;Data Source=c:/directory/demo.dbc;Collating Sequence=machineInformixInformix ODBC Connection StringDriver={Informix-CLI 2.5 (32 Bit)};Server=demoservername;Database=demodb;Uid=myusername;Pwd=mypasswdInformix OLEDB Connection StringProvider=Ifxoledbc.2;User ID=myusername;password=mypasswd;Data Source=demodb@demoservername;Persist Security Info=trueMySQLMySQL ODBC Connection StringDRIVER={MySQL ODBC 3.51 Driver};SERVER=myservername;PORT=3306;DATABASE=mydemodb; USER=myusername;PASSWORD=mypasswd;OPTION=3;MySQL OLEDB Connection StringProvider=MySQLProv;Data Source=mydemodb;User Id=myusername;Password=mypasswd;OracleOracle ODBC Connection StringDriver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword;Oracle OLEDB Connection StringProvider=msdaora;Data Source=mydemodb;User Id=myusername;Password=mypasswd;Oracle .Net Connection StringData Source=mydemodb;User Id=myusername;Password=mypasswd;Integrated Security=no;SQL ServerSQL Server ODBC Connection String - Database LoginDriver={SQL Server};Server=myservername;Database=mydemodb;Uid=myusername;Pwd=mypasswd;SQL Server ODBC Connection String - Trusted ConnectionDriver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes;SQL Server OLEDB Connection String - Database LoginProvider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd;SQL Server OLEDB Connection String - Trusted ConnectionProvider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI;SQL Server .Net Connection String - Database LoginServer=myservername;Database=mydemodb;User ID=myusername;Password=mypasswd;Trusted_Connection=FalseSQL Server .Net Connection String - Trusted ConnectionServer=myservername;Database=mydemodb;Integrated Security=SSPI;SybaseSybase ODBC Connection StringDriver={SYBASE ASE ODBC Driver};Srvr=myservername;Uid=myusername;Pwd=mypasswdSybase OLEDB Connection StringProvider=Sybase.ASEOLEDBProvider;Server Name=myservername,5000;Initial Catalog=mydemodb;User Id=myusername;Password=mypassword原文参见:http://blog.csdn.net/yufei_yxd/article/details/5510593 0 0
- 各种数据源的ConnectString[转]
- 各种数据源的ConnectString【转】
- ConnectString ()函数的介绍
- ConnectString ()函数的介绍
- ConnectString
- ConnectString中enlist设置的含义
- 虚拟主机下, Access数据库ConnectString相对路径的配置
- webconfig(connectstring)
- JDBC connectstring
- spring 配置各种数据源
- 各种数据源配置
- sparksql各种数据源
- 各种数据源的配置,及对应jar包的引用
- Flex Menu 各种数据源定义方式的区别
- WPF绑定各种数据源之object数据源
- WPF绑定各种数据源之xml数据源
- c#利用OLEDB接口访问Access、Sql Server的ConnectString格式
- Spring连接各种数据库数据源
- Python安装完毕后,提示找不到ssl模块的解决步骤
- 机器学习算法——条件随机场CRF
- sftp.sh
- window实验
- sdutacm-顺序表应用2:多余元素删除之建表算法
- 各种数据源的ConnectString【转】
- Solution for link error:Cannot Open File 'python27_d.lib'
- 设计模式 策略模式 以角色游戏为背景
- linux常用命令sed
- 设计模式——简单工厂模式分析
- Beautiful Soup
- UIViewController 相关生命周期总结 和 UIView 总结
- 主成分分析(PCA)
- 通俗理解卷积神经网络