ODBC -- Oracle entries

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Triton46
Charter Member
Charter Member
Posts: 83
Joined: Fri Feb 07, 2003 8:30 am

ODBC -- Oracle entries

Post by Triton46 »

I haven't done this in a while...so I need some help. :lol:

In order to call on Oracle servers via the ODBC stage, you have to enter the information in two places:

uvodbc.config (located in the projects directory) and odbc.ini...that is my problem. I cannot find odbc.ini, where is its location?

The help file says opt/
Last edited by Triton46 on Wed Feb 18, 2004 10:45 am, edited 1 time in total.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Do a "cat /.dshome" to see where the file is located. This is the "engine" directory. You do not need to recycle services to make changes effective in the odbc.ini file or the uvconfig files.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Triton46
Charter Member
Charter Member
Posts: 83
Joined: Fri Feb 07, 2003 8:30 am

Post by Triton46 »

Thanks Ken.

I looked in the engine directory but don't see a listing for it. I know its somewhere because we have ODBC entries in other jobs.
Triton46
Charter Member
Charter Member
Posts: 83
Joined: Fri Feb 07, 2003 8:30 am

Post by Triton46 »

I found it in branded_odbc...but I don't see any other connection information for the ones I currently have working. :?:
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Post by ogmios »

The file is in the DSEngine directory but it's called ".odbc.ini" (it's a hidden file). If you do

Code: Select all

ls -las
in the DSEngine directory the file should appear.

Ogmios
Triton46
Charter Member
Charter Member
Posts: 83
Joined: Fri Feb 07, 2003 8:30 am

Post by Triton46 »

I tried ls -las but it still is no where to be found. I am working with DS 5.2 if that helps.
Triton46
Charter Member
Charter Member
Posts: 83
Joined: Fri Feb 07, 2003 8:30 am

Post by Triton46 »

Missed the .odbc.ini


Found it now!

Thanks!
Post Reply