By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,276 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,276 IT Pros & Developers. It's quick & easy.

connect to db2 server with odbc

P: n/a
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

Aug 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think that the best way to configure the ODBC connections is by
having the DB2 Run time client (That's because, and correct me if I'm
wrong, the odbc connects with the client wich connect to the database).

That's why if the run time client is not configure properly the odbc
connection won't work.
If you have the runtime client you first need to catalog the node (that
is the remote instance) then the database (CATALOG DATABASE) both
command are simple explain if you google it.
Once that is configure, the odbc is really simple, because the database
that you have cataloged in your machine will be in the drop down list.

Hope this help

Regards,

Max
Thijs wrote:
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
Aug 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.