Creation of DSN Connection

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
nagarjuna900
Participant
Posts: 35
Joined: Mon Dec 29, 2008 2:22 am
Location: chennai

Creation of DSN Connection

Post by nagarjuna900 »

Hi,

I have two servers, one for Datastage and another for Database.

I created the DSN connnection for the database in two servers( tried with individual server also), but that DSN not displaying in datastage.

How can i solve this?

Thanks,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DataStage does not recognize User DSNs - you must use a System DSN or a file DSN.

Secondly, as well as setting up a DSN, you may need to record the fact of that DSN's existence in a uvodbc.config file.
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