SQLServerCE Connection string

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Gidday,

Can anybody give me some info on the connection string required for
SQLServerCE. All the examples I have seen show the connection string
pointing to a .sdf file. None of these examples explained what was used to
generate this file or what it contains.

I am writing an app using SQLServerCE but keep falling over at the
connection string part. I tried to use a standard ADO.Net connection string
but it doesn't like it at all.

My app will need to talk to the SQLServerCE database and also reach external
databases. How does the connection string differ for each of these
scenarios?

Any help appreciated.

Cheers
 
Hello,

The following provides a decent walkthrough of Working with SQL Server CE
Databases.
http://msdn.microsoft.com/library/d...conWalkthroughCreatingSQLServerCEDatabase.asp

Another good general resource for Sql CE is
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_evtuv/html/etconSQLServerCE.asp

Have fun,

Tom


--
Tom Krueger
Microsoft Corporation
Program Manager
http://weblogs.asp.net/tom_krueger

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
 
Back
Top