A SqlConnection.ConnectionString code may look like this in C#:
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = "Data Source=SqlServerName; User ID = sa;
Password=MyPassword123; Initial Catalog=Northwind; ";
sqlconn.Open();
...
All of the connection string properties are described in detail in the
VS.NET help topic "SqlConnection.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.
----------------------------------------------------------------------------
----------------------------------------
--------------------
Content-Class: urn:content-classes:message
From: "Butt Chin Chuan" <
[email protected]>
Sender: "Butt Chin Chuan" <
[email protected]>
Subject: Connection String to Server via Pocket Pc?
Date: Thu, 24 Jul 2003 00:25:17 -0700
Lines: 5
Message-ID: <
[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNRtLtuvmr+P+rZRneCqlr9q3E8Tg==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.framework.compactframework
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:29074
NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
I want to connect to the server database via Pocket Pc,
then in the server database, to activate some Stored
Procedures to read, create and update some tables before
pulling it into my pocket pc. Can anyone show me what is
the syntax for this connection string? Thank you.
