SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:58 AM
| ||||
| ||||
 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      |
|
02-27-2008, 07:58 AM
| ||||
| ||||
| 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 |
 |
« delete lock problem
|
Informatica ETL developer needed with PL/SQL for 3 months CTH in southern CA »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:57 PM.
