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?
