Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / November 2007

Tip: Looking for answers? Try searching our database.

How-to

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pradyumna - 22 Nov 2007 08:49 GMT
   
hi..I am totally novice to WinCE environment..I am using eVC++ 4.0sp4
version and SDK 5.0, I want to install database(SQLCE) on Win Ce platform
what should i do..
plz help me..its urgent..also plz give any links if possible..
James Hunter Ross - 26 Nov 2007 17:40 GMT
There are a few versions available at this point, from the older 2.0 to the
compelte re-write 3.0, and the more seasoned and robust 3.1.  Still in beta
is 3.5, also known as SQL Server Compact Edition, which will be released
with SQL Server 2008 withn a month or so.

I usually just google "download sqlce" or "downlaod sql server compact
edition" and find the MS link quickly.  Have a device cradled and connected
with ActiveSync when you download and install to your workstation.  The 2.0
version install is somewhat different that the various 3.x versions.  With
the 3.x releases there are CAB files for the various components for each
Mobile OS and CPU flavor.  You only need to use the CAB files for the
features you need.  Be brave, the information is available through the MS
links and the documentation that gets installed with each particular
version.  Of course, once installed the real fun can begin.

James
Dirk Michaelsen - 27 Nov 2007 06:39 GMT
Hi James,

>I usually just google "download sqlce" or "downlaod sql server compact
>edition" and find the MS link quickly.  Have a device cradled and connected
[quoted text clipped - 5 lines]
>links and the documentation that gets installed with each particular
>version.  Of course, once installed the real fun can begin.

I have downloaded the 3.1 version and installed it to my development
pc. Unfortunately Visual Studio 2005 doesn't seem to recognize the
presence of the newer version of SQL CE. Do you know how to force VS
to use the newer version of the server when starting new projects?

cu
Dirk
ErikEJ - 27 Nov 2007 14:45 GMT
For detailed instructions on how to update your development environment for
SQL Compact 3.1, see Steve Lasker's blog:
http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2
005-for-use-wtih-sql-server-2005-compact-edition.aspx

Signature

Erik Ejlskov Jensen - MCTS: Mobile App Dev

> Hi James,
>
[quoted text clipped - 15 lines]
> cu
> Dirk
Dirk Michaelsen - 28 Nov 2007 07:52 GMT
Erik,

>For detailed instructions on how to update your development environment for
>SQL Compact 3.1, see Steve Lasker's blog:
>http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2
005-for-use-wtih-sql-server-2005-compact-edition.aspx

thank you very much for your assistance. This blog helped me
installing the SQL Compact 3.1 to Visual Studio.

Unfortunately there is still one glitch and maybe you can help me
fixing it:

After I created a new C# Windows project, added a database to it,
created a table, dragging the table to the form and finally startet
the application, I get an DllNotFoundException telling me the
sqlceme30.dll is missing. I have to copy sqlceme30.dll, sqlceqp30.dll
and sqlcese30.dll manually to the projects bin/Debug directory to get
it running. How can I tell VS to do this job for me when adding a
database to the project?

Dirk
ErikEJ - 28 Nov 2007 09:47 GMT
You should install the Desktop runtime, and all components will be globally
available.
Signature

Erik Ejlskov Jensen - MCTS: Mobile App Dev

> Erik,
>
[quoted text clipped - 17 lines]
>
> Dirk
Dirk Michaelsen - 28 Nov 2007 10:27 GMT
Erik,

>You should install the Desktop runtime, and all components will be globally
>available.

I actually installed the desktop runtime (it's step 2 in Steve
Lasker's Blog which I followed step-by-step). But the required DLLs
are not part of the SQL Server CE installation. The mentioned DLLs can
be found in the Common/IDE directory of Visual Studio 2005. It looks
like VS still uses SQL Server Mobile Edition instead of Compact
Edition.

Dirk
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.