怎么也访问不了DB2，哪位高人给解答一下【】【【】【】【】【】【】【】【】

[god_sun]

::CoInitialize(NULL);
HRESULT hr = m_Con.CreateInstance("ADODB.Connection");
if(SUCCEEDED (hr))
m_Con->Open ("Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=10.78.28.121;Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;Default Schema=MySchema;User ID=dbsa;Password=123", "", "", adModeUnknown);


.....
老是Open报异常

[god_sun]

我在odbc数据源里。看到系统DNS下有个SAMPLE的数据源，测试连接可以用
如何通过这个数据源让我的程序连上db2.

[god_sun]

竟然没人回答，唉～～～～～～～！

[ouyh12345]

google一下。

以下是csdn中的一个答案：

2 楼masterz（www.fruitfruit.com）回复于 2003-01-20 12:29:08 得分 0

OLE DB Provider for DB2 (from Microsoft)
For TCP/IP connections

oConn.Open = "Provider=DB2OLEDB;" & _
"Network Transport Library=TCPIP;" & _
"Network Address=xxx.xxx.xxx.xxx;" & _
"Initial Catalog=MyCatalog;" & _
"Package Collection=MyPackageCollection;" & _
"Default Schema=MySchema;" & _
"User ID=MyUsername;" & _
"Password=MyPassword"

For APPC connections

oConn.Open = "Provider=DB2OLEDB;" & _
"APPC Local LU Alias=MyLocalLUAlias;" & _
"APPC Remote LU Alias=MyRemoteLUAlias;" & _
"Initial Catalog=MyCatalog;" & _
"Package Collection=MyPackageCollection;" & _
"Default Schema=MySchema;" & _
"User ID=MyUsername;" & _
"Password=MyPassword"

[ouyh12345]

http://topic.csdn.net/t/20040817/16/3283231.html

[god_sun]

那些字符串都试了，没用。

[shanhqk]

服务器端开放的端口号LZ没有写上