Newbie:How to connect to a DB2server from a PC using WINXP ODBC System DSN?
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?