View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 07:58 AM
Thijs
 
Posts: n/a
Default connect to db2 server with odbc

Hi,

i'm new to db2, so the answer on this question is maybe verry simple
(or not)...


i've installed db2 on a server, and now, I want to make a connection
with odbc from a client (windows 2000). I installed the IBM DB2 odbc
driver.


To make a odbc connection i go to the 'odbc data source administrator',

then 'add' and select the IBM DB2 ODBC DRIVER. I give a name, and then
pushed the add button for configuring the database. In the tcp/ip tab,
I fill in the db name, host name, and port number. In the first tab i
fill the username (db2admin) and the password.


Than i push ok, and the data source is made.


Now, if i want to test it, i go to configure, and try the 'connect'
button. Then i've got the error:


SQL1097N The node name was not found in the node directory.
SQLSTATE=42720


Anyone knows what to do with it?


Thanks in advance,


Thijs

Reply With Quote