regarding odbc connection to connect to universe

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
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

regarding odbc connection to connect to universe

Post by vijaykumar »

hi,
iam trying to connect the sales datasourcewhich is in uv folder.
iam getting error.The error is like this, dbcapper-could not login to database as invalid username and password.how can i figure out the actual user name and password,iam logging in as administrator.

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

Post by ray.wurlod »

Experiment with the user name. UniVerse can be finicky; it may need the user name to be qualified by the machine name or the domain name, depending upon where it's authenticated. There is a system table called UV.LOGINS on Windows machines where you can map the three variants to a single user.

And, of course, the usual things - make sure Caps Lock is off and that casing is correct in the password.
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