Hi,
I have just migrated a project from our dev server to the QA server. In administrator I updated the parameters for the DSN name/pwd/uid for the UDB server. When all the jobs were created the parameters had a default value of $PROJDEF. When I go and do a get sql info on any of the ODBC stages in the QA environment I get a uid/pwd error. I did test the values I entered in administrator here and they work when I manually enter.....Have I missed a step?
Thanks - - John
ODBC log in issue when migrating from dev to QA
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
$PROJDEF picks up its values from the environment variables that have been set in the Administrator client, and which are stored on the server in a file called DSParams in the project directory. I suspect you've missed migrating these environment variable definitions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
If you are using any special characters in your password, wrap it in quotes and try.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am