missing DSN entry

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

missing DSN entry

Post by vipson »

Hello again..

I am trying to create ODBC connection and I have the needed entry under .odbc.ini and uvodbc.config files. For some reason I can not see the DSN in my drop down list.
What could be wrong? What did I miss?
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

uvodbc.config in your project needs an entry as well. I usually create a soft link for uvodbc.config under all my projects to point to uvodbc.config in the engine. This way I need to create/maintain dsn entries in only one place.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

Good suggestion

Post by vipson »

You are right about that file. There is one at project level.
Though, in my case it is a file. I like your suggestion. Easy to maintain and consistent results...

Now, let me try to change the file and see...
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

Thanks a bunch

Post by vipson »

Yes...It is working...
Thank you so much..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I prefer to maintain separate uvodbc.config files per project. That way the development project can not "accidentally" see production DSNs (and vice versa).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply