SQL Serve Password with Escape Character
Posted: Thu Jul 19, 2007 2:02 pm
Hello...
We are trying to connect to MS SQL Server using ODBC Stage.
The password is "n8aC\Y)D"
We are able to view data but not able to run the job with this Password.
We tried using Double Quotes("), Single Quotes ('), and Escape Characters but not able to run the job.
The user connection works fine when connected using Aqua Data Studio.
Pls advise..
We are trying to connect to MS SQL Server using ODBC Stage.
The password is "n8aC\Y)D"
We are able to view data but not able to run the job with this Password.
We tried using Double Quotes("), Single Quotes ('), and Escape Characters but not able to run the job.
The user connection works fine when connected using Aqua Data Studio.
Pls advise..