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
Triton46
Charter Member
Posts: 83 Joined: Fri Feb 07, 2003 8:30 am
Post
by Triton46 » Wed Feb 18, 2004 10:20 am
I haven't done this in a while...so I need some help.
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 » Wed Feb 18, 2004 10:27 am
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
Posts: 83 Joined: Fri Feb 07, 2003 8:30 am
Post
by Triton46 » Wed Feb 18, 2004 10:32 am
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
Posts: 83 Joined: Fri Feb 07, 2003 8:30 am
Post
by Triton46 » Wed Feb 18, 2004 10:46 am
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 » Wed Feb 18, 2004 10:57 am
The file is in the DSEngine directory but it's called ".odbc.ini" (it's a hidden file). If you do
in the DSEngine directory the file should appear.
Ogmios
Triton46
Charter Member
Posts: 83 Joined: Fri Feb 07, 2003 8:30 am
Post
by Triton46 » Wed Feb 18, 2004 10:59 am
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
Posts: 83 Joined: Fri Feb 07, 2003 8:30 am
Post
by Triton46 » Wed Feb 18, 2004 11:01 am
Missed the . odbc.ini
Found it now!
Thanks!