connect to db2 server with odbc

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Thijs
    #1

    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

    Tags: sql1097n, sqlstate
    • The Maxx
      #2
      Re: connect to db2 server with odbc

      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

        Comment

        Previous template Next
        Working...