读书人

vc6 连接db2数据库的连接串是什么啊该

发布时间: 2012-03-11 18:15:39 作者: rapoo

vc6 连接db2数据库的连接串是什么啊?
请问如何在VC6中连接DB2数据库

[解决办法]
OLE DB, OleDbConnection (.NET) 微软公司提供的驱动

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适配器

TCP/IP
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;

Protocol=TCPIP;Port=50000; Uid=myUsername;Pwd=myPassword;


ODBC

标准
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;

Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
[解决办法]
http://www.connectionstringsMicrosoft OLEDB provider for DB2.com/ibm-db2

Microsoft OLEDB provider for DB2
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;

IBM OLE DB Provider for DB2
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword;

读书人网 >IBM DB2

热点推荐