Solved

db2

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

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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22755812
is the db2 client installed on that machine?
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 504 total points
ID: 22755850
0
 

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 143

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Automatically Update Cross Reference Field in Document Header 2 80
Cognos BI 7.5 calculated date syntax 2 67
Outlook 2012 VBA: Object missing 14 41
Modify select statment 10 35
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
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 …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

830 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