sql server 2008 - DB2 Connect issue using Native OLE DB\MS OLEDB Provider for DB2 -
i downloaded , installed driver setup file, db2oledb.exe, here:
http://download.microsoft.com/mwg-internal/de5fs23hu73ds/progress?id=hylbkufgnl
using connection string worked on pc, tried create connection object in ssis package. when tested connection got error:
test connection failed because of error in initializing provider. tcpip socket error has occurred (10057): request send or receive data disallowed because socket not connected , (when sending on datagram socket using sendto call) no address supplied.
any suggestions on cause of error , how might resolve issue?
by way, when use db2 configuration set utility , test connection within that, able connect.
what other info can provide answer question?
thank you
could related blocked port?
if follow steps illustrated here: http://www.bidn.com/blogs/patrickleblanc/ssis/700/connecting-to-db2-using-ssis still same result?
maybe silly question, did restart computer after installation? admin user on 1 machine , not on other?
you try verify port connectivity quick telnet command:
telnet your-db-host your-db-listening-port
if connects, 1 off list.
Comments
Post a Comment