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