当前位置: 代码迷 >> DB2 >> vc6 连接db2数据库的连接串是什么啊该怎么处理
  详细解决方案

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

热度:6988   发布时间:2013-02-26 00:00:00.0
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;
  相关解决方案