各位遇到过这种情况吗?在线等。即使使用DB2客户端工具导出为DSN文件,用ADO-ODBC的方式连接还是不行,提示需要使用"TCP/IP"方式,当前使用的"SOCKS"。奇怪,DSN文件里已经指定了TCPIP方式呀,怎么回事。以下是导出来的DSN文件内容:[ODBC]
DRIVER=IBM DB2 ODBC DRIVER
DATABASE=TESTDB1
PROTOCOL=TCPIP
PORT=50000
HOSTNAME=192.168.0.10
DRIVER=IBM DB2 ODBC DRIVER
DATABASE=TESTDB1
PROTOCOL=TCPIP
PORT=50000
HOSTNAME=192.168.0.10
OLE DB Provider for DB2 (from Microsoft)
For TCP/IP connectionsoConn.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 connectionsoConn.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"
不过既然用了ADO 还用ODBC做什么
是不是数据库只容许TCP/IP连接呢
TCP/IP方式