Solved

db2

Posted on 2008-10-20
11
1,125 Views
Last Modified: 2012-05-05
how to connect db2 database
0
Comment
Question by:maxiflex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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 …

752 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