Sql Connection string

  • Thread starter Thread starter John Medany
  • Start date Start date
J

John Medany

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.
--------------------
 
Yep spotted that one - got it working

thanks
John

"Ilya Tumanov [MS]" said:
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" <[email protected]>
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: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: cpc3-ayle1-5-0-cust104.wtfd.cable.ntl.com 82.19.246.104
Path:
Click to expand...
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
Click to expand...
Click to expand...
 
Also try using the server's IP address instead of the name "cube"

--
Alex Feinman
---
Visit http://www.opennetcf.org
"Ilya Tumanov [MS]" said:
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" <[email protected]>
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: <[email protected]>
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
Click to expand...
Click to expand...
 
Back
Top