SQL Serve Password with Escape Character

vkumar · Post by **vkumar** » 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..

mctny · Post by **mctny** » Thu Jul 19, 2007 2:05 pm

how about changing the password?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 19, 2007 4:51 pm

Is the first character a space or some non-printing character? It's possible that, if it's a space, it's been trimmed. I know that's not correct (and would be a bug), but that's my guess.

vkumar · Post by **vkumar** » Fri Jul 20, 2007 9:02 am

Finally...it worked

An additional Escape Character for the Escape Character and Double quotes are used.

Actual Password n8aC\Y)D
But is works if passed like this "n8aC\\Y)D"

Thanx

DSXchange

SQL Serve Password with Escape Character

SQL Serve Password with Escape Character

Re: SQL Serve Password with Escape Character