Re: Sql Connection string

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Medany (gaspode_at_gaspode.net)
Date: 03/16/05


Date: Wed, 16 Mar 2005 00:10:58 -0000

Yep spotted that one - got it working

thanks
John

""Ilya Tumanov [MS]"" <ilyatum@online.microsoft.com> wrote in message
news:vOPTgcbKFHA.1140@TK2MSFTNGXA02.phx.gbl...
> If you're not using windows security, why do you have "integrated
> Security=SSPI" in your connection string?
>
> Best regards,
>
> Ilya
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
> > From: "John Medany" <gaspode@gaspode.net>
> > Subject: Sql Connection string
> > Date: Tue, 15 Mar 2005 23:05:33 -0000
> > Lines: 23
> > X-Priority: 3
> > X-MSMail-Priority: Normal
> > X-Newsreader: Microsoft Outlook Express 6.00.3790.224
> > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.224
> > Message-ID: <eA6G8NbKFHA.2212@TK2MSFTNGP12.phx.gbl>
> > Newsgroups: microsoft.public.dotnet.framework.compactframework
> > NNTP-Posting-Host: cpc3-ayle1-5-0-cust104.wtfd.cable.ntl.com
82.19.246.104
> > Path:
>
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> 2.phx.gbl
> > Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.compactframework:73307
> > X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
> >
> > Hi
> >
> > I'm having connection string problems
> >
> > I am trying to connect to an SQL2000 server
> > the server name is cube, I am not using windows security just the sa
> > account with a blank password.
> > @"UID=SA;Password="";Integrated
> > Security=SSPI;Server=cube;Database=CS01JPMFYP"
> >
> >
> >
> > Is wrong i think
> >
> >
> >
> > Can some one fix this ??
> >
> > Help
> >
> > John
> >
> >
> >
>



Relevant Pages