关于数据库连接字符串问题(第四部分连接 IBM DB2)
来源:互联网 发布:合拍在线网络借贷 编辑:程序博客网 时间:2024/05/17 04:34
IBM 的DB2数据库应用的还比较广泛,不过关于连接这一块的文章还是比较少的,所以本人就在这贴出关于DB2的数据库,连接方式,共大家学习。
Providers for IBM DB2 DB2 .NET Data Provider Type: .NET Framework Class Library Manufacturer: IBM Customize string Standard Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; The Server key value syntax is a server name / ip address and an optional port number (note the : in between). Defining the connection pooling pool size Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Max Pool Size=100;Min Pool Size=10; Disable connection pooling Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Pooling=false; Connection pooling, time in pool Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Connection Lifetime=60; Defines how many seconds the connection can remain idle in the pool before its removed from the pool. Connection pooling, do not pool Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Connection Reset=false; Specifying schema Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; CurrentSchema=mySchema; All unqualified SQL objects used with the current connection will be qualified with the provide schema name Microsoft OLEDB provider for DB2 Type: OLE DB Provider Manufacturer: Microsoft Customize string 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=myUsername;Password=myPassword; APPC Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword; IBM OLE DB Provider for DB2 Type: OLE DB Provider Manufacturer: IBM Customize string TCP/IP Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword; .NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Manufacturer: Microsoft Customize string Bridging to IBM OLE DB Provider for DB2 This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class. Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword; IBM DB2 Driver for ODBC and CLI Type: ODBC Driver Manufacturer: IBM Customize string Standard Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234; Protocol=TCPIP;Uid=myUsername;Pwd=myPassword; .NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Manufacturer: Microsoft Customize string Bridging to IBM DB2 Driver for ODBC and CLI This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class. Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234; Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
Usage: IBM.Data.DB2.DB2Connection
More info about this class library »
example values »
Usage: Provider=DB2OLEDB
More info about this provider »
example values »
Usage: Provider=IBMDADB2
More info about this provider »
example values »
Usage: System.Data.OleDb.OleDbConnection
More info about this wrapper class library »
example values »
Usage: Driver={IBM DB2 ODBC DRIVER}
More info about this driver »
example values »
Usage: System.Data.Odbc.OdbcConnection
More info about this wrapper class library »
example values »
- 关于数据库连接字符串问题(第四部分连接 IBM DB2)
- [数据库连接字符串] IBM DB2 连接字符串
- 关于数据库连接字符串问题(第二部分连接MySQL)
- 关于数据库连接字符串问题(第三部分连接Oracle)
- 关于数据库连接字符串问题(第五部分连接access-2007)
- 数据库连接字符串 - IBM DB2
- 关于数据库连接字符串问题(第一部分连接SQL Server 2008)
- C#数据库连接字符串——IBM DB2
- DB2数据库连接(jdbc连接)
- 关于Hibernate3,mysql5 数据库连接超过8小时 连接超时的问题及解决方案(部分摘自网络)
- 关于IBM.Data.DB2
- ArcEngine连接数据库IBM DB2
- ADO连接Access数据库连接字符串问题
- 关于db2连接配置的问题!!
- 关于.NET 连接DB2 错误问题
- 使用连接池连接IBM DB2数据库
- DB2数据库连接(jdbc连接)encoding not supported
- DB2字符串连接
- android 解析 xml 文档的三种方法
- 构建高性能ASP.NET站点
- 学会使用malloc,学会对指针赋值
- 判断是否已经安装vc2008运行时库
- MPEG标准
- 关于数据库连接字符串问题(第四部分连接 IBM DB2)
- struts2校验器规范错误解决
- ora-0131:Insufficient privileges
- 文档类xxxDoc.cpp中的成员函数serialize()解读
- 自定义Xcode模板
- oracle中的加密算法 (原帖http://sun177000.blog.163.com/blog/static/546178182007102111100621/)
- 第一篇-开篇之言
- ASV2011 反编译软件谁有,帮小弟破解一个SWF
- meego 1.2 详细的安装教程