Connection string

[Suedois]

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

[techgnome]

using pass?ord as a password is not very secure..... I'd change it.....

[mendhak]

Try

pass''?''ord

(That's two single quotes, not a double quote)

[Suedois]

pass?ord is just a sample

In reality, the password would be like s2*k8u?ud

[mendhak]

On second thought, also try

pass'''?'''ord

(three single quotes)

Also, do as techgnome says.

[Suedois]

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'."

[vbud]

One alternative could be to limit password characters only to alphnumerics and not to use special characters or punctuation signs...

[Suedois]

Yes, I know !

But I'm not the DBA ! I have to work with this password !