"Sandy Beach" wrote:

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