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..
SQL Serve Password with Escape Character
Moderators: chulett, rschirm, roy
SQL Serve Password with Escape Character
Thanx........
CTCT
CTCT
Re: SQL Serve Password with Escape Character
how about changing the password?
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.