db2

how to connect db2 database
maxiflexAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
sorry, but I don't know more than that about DB2.
you should find the information in the db2 installation docs, though...
the error message is not really clear:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql01027n.html

maybe this:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001936.htm
(see also the other CATALOG xxx NODE commands in the tree) ...
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
the connection strings possible are shown here, for example:
http://www.connectionstrings.com/?carrier=ibmdb2

you might want to clarify your question/problem, though.
0
 
maxiflexAuthor Commented:
Yes, sorry for my bad question. I was trying to search database, but I made o question...

I have Windows Xp operation system and I can't  find no OBBC connections.  I'm trying to set up connection using Actuate Report Designer Pro to get connection to DB2 databace which is located in other computer (Win2000 Server) but I can't get connection to this database.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the db2 client installed on that machine?
0
 
maxiflexAuthor Commented:
No, I'm just wondering where to get that db2 client. Any tips for that? I don't even know is there any free db2 clients that I can use?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
0
 
maxiflexAuthor Commented:
Thank You!

I'll check the link and inform you later If I can or can't make the connection to the database.
0
 
maxiflexAuthor Commented:
I downloaded DB2 client but still how problems. Now I got ODBC driver for DB2 but still can't get connected to database located in dfferent server. I configured ODBC driver for DB2 database in Administaror tools but when I test the connection I get error message "SQL1027N The node directory cannot be found". Any tips to correct this error?
0
 
maxiflexAuthor Commented:
Thank you again!

I'll check these links and inform you later after that.
0
 
maxiflexAuthor Commented:
Now I get connected to database! I had to set up the server name when I setup ODBC. First time I didn't do that and it was impossible to add later. I removed ODCB and set up it again, and now everything works fine. Thank you!
0
All Courses

From novice to tech pro — start learning today.