Newbie:How to connect to a DB2server from a PC using WINXP ODBC System DSN?

By rcjavier ·
How can I create a System DSN in Windows XP Pro to connect to a DB2 server on the same network using these settings:

(Start -> -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC) -> System DSN Tab -> Add Button)

on the CLI/ODBC Settings form,

Data Source Tab:
- data source name
- user ID
- password
- save password(checked)

TCP/IP tab:
- database name
- database alias
- host name/IP
- port number

I clicked OK and the new DSN appeared on the listbox. But when I Clicked the Configure button, and clicked Connect, this error appeared:

DB2 Message:
SQL10007N Message "-3000" could not be retrieved. Reason code:"5".

I can ping the server, the port is not blocked on my firewall but I cannot create a System DSN.

I have installed the:
- Microsoft Data Access
- DB2 Runtime

What have I done wrong?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums