Passing "@" to SQL connection string

Hi,
I'm using c# to connect to a sql database.
My dev work is fine and it connects; when deployed to the live environment,
it needs to have special chacters (@. and !) in it. The ! goes through fine,
but @. is removed. If I hard code the @., it's fine, but my setting is held in
a variable.
Does anybody know how I can pass the @. sign through to a ConnectionString?
I've tried escaping it with a \, but it won't compile (\@. is not a valid
escape sequence).
Thanks,
Sandy
What SQL database? Why do you need a "@."? Is it part of a UserName or
Password?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
> Hi,
> I'm using c# to connect to a sql database.
> My dev work is fine and it connects; when deployed to the live
> environment,
> it needs to have special chacters (@. and !) in it. The ! goes through
> fine,
> but @. is removed. If I hard code the @., it's fine, but my setting is held
> in
> a variable.
> Does anybody know how I can pass the @. sign through to a
> ConnectionString?
> I've tried escaping it with a \, but it won't compile (\@. is not a valid
> escape sequence).
> Thanks,
> Sandy
|||Thanks for the response.
I'm trying to connect to a SQL 2000 db and the "@." starts the password. The
DB administrator set it up for the user account I'm allowed to log in as.
Cheers,
Sandy
"William (Bill) Vaughn" wrote:

> What SQL database? Why do you need a "@."? Is it part of a UserName or
> Password?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> "Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
> news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
>
>
|||Thanks for helping, but I've managed to track down the problem and it had
nothing to do with the "@." in the password.
I'm encrypting/decrpyting the password, and the decrypt has a list of valid
characters. Guess what? "@." wasn't one of them!
So, again, thanks for you help and time.
Cheers,
Grahame
"Sandy Beach" wrote:
[vbcol=seagreen]
> Thanks for the response.
> I'm trying to connect to a SQL 2000 db and the "@." starts the password. The
> DB administrator set it up for the user account I'm allowed to log in as.
> Cheers,
> Sandy
> "William (Bill) Vaughn" wrote: