Solved

db2

Posted on 2008-10-20
11
1,113 Views
Last Modified: 2012-05-05
how to connect db2 database
0
Comment
Question by:maxiflex
  • 6
  • 4
11 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 504 total points
ID: 22755755
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
 

Author Comment

by:maxiflex
ID: 22755788
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22755812
is the db2 client installed on that machine?
0
 

Author Comment

by:maxiflex
ID: 22755825
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
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 504 total points
ID: 22755850
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:maxiflex
ID: 22755865
Thank You!

I'll check the link and inform you later If I can or can't make the connection to the database.
0
 

Author Comment

by:maxiflex
ID: 22757494
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
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 504 total points
ID: 22757935
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
 

Author Comment

by:maxiflex
ID: 22764746
Thank you again!

I'll check these links and inform you later after that.
0
 

Author Comment

by:maxiflex
ID: 22765118
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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now