Hi Roberto,
When you use Integrated Security = SSPI, you're asking SQL Server to use a
Windows account to login, so you will need to pass a valid Windows User
Name and Password. If you wish to use a SQL Server account, then do not
pass Integrated Security=SSPI in the connection string.
Either way, you must use the user id and password properties in the
ConnectionString.
Kevin Boske
(
[email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:
http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: "Roberto M. Oliva" <
[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Connecting to an SQL Server Database
Date: Mon, 17 Nov 2003 10:03:56 +0100
Organization: Telefonica Data Espagna
Lines: 14
Message-ID: <
[email protected]>
NNTP-Posting-Host: 85.red-80-33-6.pooles.rima-tde.net
X-Trace: nsnmpen2-gest.nuria.telefonica-data.net 1069067202 23699
80.33.6.85 (17 Nov 2003 11:06:42 GMT)
X-Complaints-To: (e-mail address removed)-data.net
NNTP-Posting-Date: Mon, 17 Nov 2003 11:06:42 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.co
m!nsnmpen1-lo.nuria.telefonica-data.net!nsnmpen2-lo.nuria.telefonica-data.ne
t!not-for-mail
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:38802
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
Hi all!
I am unable to connect to a SQL Server Database (MSDE not an SQL Server CE)
using the SQLClient namespace.
My NET CF application runs on the emulator, but I cannot get my Connection
String to connect.
I have tried to use the Integrated Security=SSPI parameter, but... then I
have the following questions: Which SQL Server login (user/password) is the
device using? and how can I set up on the SQL Server logins?.
Thanks a lot
Roberto
