DB2OLEDB : error messages

  • Article

1. Could not connect to data source 'ENTERPRIZE_UDL':
A TCPIP socket error has occured (10061): No connection could be made because the target machine actively refused it.
 SQLSTATE: 08S01, SQLCODE: 10061

you get this error message when

a) PORT Number on Connection string is not the correct Port number where the DB2inst is running on the DB2 server. OR

b) there is no db2inst running on server at all OR

c) there is no TCP /IP services started on remote DB2 server where you are trying to connect to.

troubleshoot :

1. Verify the db2inst is up and running on server, you can use "netstat" to also verify the port Numbers for db2service.