-
Connection string
Hi,
I'm bulding a connection string to connect to database. My problem is that the password have a questionmark (?) inside.
(IE : pass?ord)
In Query Analyser, I simply put pass'?'ord and the connection is ok.
In ado.net, if I put ";password=pass'?'ord", I get a message that this there is invalide caractères. If I didn't put the quote, I get a message that the connection is invalide.
Someone have an idea ?
Stéphane
-
using pass?ord as a password is not very secure..... I'd change it.....
-
Try
pass''?''ord
(That's two single quotes, not a double quote)
-
Security
pass?ord is just a sample
In reality, the password would be like s2*k8u?ud
-
On second thought, also try
pass'''?'''ord
(three single quotes)
Also, do as techgnome says. :D
-
Error
Doesn't work with 2 or 3 quotes:
Message :
"Expected ';' delimiter in connection substring 'Data Source=XXX; Initial Catalog=XX;user id =XX;password='''?'''xx'."
-
One alternative could be to limit password characters only to alphnumerics and not to use special characters or punctuation signs...
-
Limitation
Yes, I know !
But I'm not the DBA ! I have to work with this password !