ODBC log in issue when migrating from dev to QA

JPalatianos · Post by **JPalatianos** » Thu May 24, 2007 1:58 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu May 24, 2007 3:07 pm

$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.

JoshGeorge · Post by **JoshGeorge** » Thu May 24, 2007 7:38 pm

If you are using any special characters in your password, wrap it in quotes and try.

JPalatianos · Post by **JPalatianos** » Fri May 25, 2007 9:04 am

Ended up being a subtle typo while entering params in QA.
Thank you to everyone for offering their help.
~ ~John