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

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" <(E-Mail Removed)>
> 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: <(E-Mail Removed)>
> 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
>
>
>

Yep spotted that one - got it working

thanks
John

""Ilya Tumanov [MS]"" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)>
> > 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: <(E-Mail Removed)>
> > 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
> >
> >
> >
>

Also try using the server's IP address instead of the name "cube"

--
Alex Feinman
---
Visit http://www.opennetcf.org
""Ilya Tumanov [MS]"" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)>
>> 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: <(E-Mail Removed)>
>> 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
>>
>>
>>
>