Page 1 of 1
Problem with DSN creation
Posted: Mon Mar 08, 2010 12:34 am
by arnie_nits
Hi,
I am trying to create a DSN . I have made an entry in .odbc.ini file.
But thats not working. Is anything else needed to be done?
regards,
Arnie.
Re: Problem with DSN creation
Posted: Mon Mar 08, 2010 12:45 am
by nmed27
Create an entry in uvodbc.config located in your DSHOME.
Posted: Mon Mar 08, 2010 1:48 am
by ray.wurlod
Create an entry in the uvodbc.config file in your project directory if you want to limit that project to a subset of the available DSNs.
Use the test facilities in branded_odbc to check your work. Then use DS.CONNECT within dssh to test whether DataStage can use the DSN.
Re: Problem with DSN creation
Posted: Tue Mar 09, 2010 3:07 am
by hailun
nmed27 wrote:Create an entry in uvodbc.config located in your DSHOME.
After finishing this step,please also make one copy of the uvodbc.config locating in your DSHOME under the project folder if you created this project earlier than updating the .odbc.ini/uvodbc.config....
Re: Problem with DSN creation
Posted: Tue Mar 09, 2010 3:08 am
by hailun
nmed27 wrote:Create an entry in uvodbc.config located in your DSHOME.
After finishing this step,please also make one copy of the uvodbc.config locating in your DSHOME under the project folder if you created this project earlier than updating the .odbc.ini/uvodbc.config....