Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Your site is one of the cleanest and BEST forums that I have seen. I have sent quite a few people your way. Keep up the good work!!!"
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > DBMS Packages > IBM: DB2 Forum

ODBC to AIX DB2 (I know...)

thread178-1690117
Read More Threads Like This One
progenysend (TechnicalUser)
6 Aug 12 20:02
Hi All,

I'm sure this one's been beat into the ground, but I can't find a good answer. I'll start this off by saying I'm a Business Objects and Crystal developer. I'm not good with databases and I know nothing of Unix or Linux.

I've got Business Objects on a Windows 7 machine.
I've got a db2 database on the network on an AIX machine.
I've installed the DB2 ODBC driver on my machine.

I can't get the ODBC to work at all. I can't even figure out where to put the IP Address and Port or anything. The end result I need is to connect Business Objects to this db2. The easiest way I know to connect anything to Business Objects is ODBC.

I've read the IBM documents on DB2 ODBC and about every post I can find, but it's just not doing it for me. My DBA's say they can't help me because they don't know Windows. Really I just need some step by step idiot instructions. I appreciate any help you can send my way.

Thanks
papadba (MIS)
6 Aug 12 23:45
Suggest you find and talk with whoever supports db2 on aix. Are these the same dbs'a who say they don't know Windows?

Someone should know how to connect to db2 on aix . . .
progenysend (TechnicalUser)
7 Aug 12 1:30
Yep. Same guys. I'm a contractor and I've only been around 6 days. I'm not really getting much help.
mikrom (Programmer)
7 Aug 12 2:39
IMO you should install a DB2 client for windows, which should contain the ODBC driver too.
http://www.db2dean.com/Previous/DB2Client.html
progenysend (TechnicalUser)
8 Aug 12 12:07
While I was not able to set up the odbc yet, loading the client got me the drivers I needed to create the aliases I needed to connect directly with Crystal Reports DB2 connector. Thanks for the tip, mikrom.
SkipVought (Programmer)
8 Aug 12 12:26
Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)

opens the ODBC Data Source Adminstrator.

Open the System DSN Tab

ADD the DB2 driver. This dialog is where you add the Host, Port, UID, Password and any other required property selections. You might also look at the Advanced settings and MORE.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Truusvlugindewind (Programmer)
24 Aug 12 6:50
suppose you have a db2 server with tcipip# 192.168.1.100 and a db2instance listening to port 50000. There is a database called mydbase running under control of that instance. You need te access that database by means of ODBC.
It is just 3 simple lines, just do not forget to execute them in the "db2cmd" box an not in the normal cmd windows shell:

CODE

db2 -v "catalog tcpip node mydbnode remote  192.168.1.100 server 50000" 
db2 -v "catalog   database mydbase  at node mydbnode"   
db2 -v "catalog system odbc data source     mydbase"
That's all folks!
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To IBM: DB2

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close