db2

how to connect db2 database
maxiflexAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]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
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the db2 client installed on that machine?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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]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
Guy Hengel [angelIII / a3]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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.