Page 1 of 1

ODBC log in issue when migrating from dev to QA

Posted: Thu May 24, 2007 1:58 pm
by JPalatianos
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

Posted: Thu May 24, 2007 3:07 pm
by ray.wurlod
$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.

Posted: Thu May 24, 2007 7:38 pm
by JoshGeorge
If you are using any special characters in your password, wrap it in quotes and try.

Posted: Fri May 25, 2007 9:04 am
by JPalatianos
Ended up being a subtle typo while entering params in QA.
Thank you to everyone for offering their help.
~ ~John