Connection String and choosing correct version

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waldemar - 12 Oct 2007 09:52 GMT

Hi to all!

I´m developing with .NET 2.0 Compact Edition 1 year, and some of the
developed application are using the SQL-Server-Mobile/SQL-Server-CE. But from
a while I have some questions, which I can´t answer myself.
1. I was installing the server CE 3.1 and SQL Everywhere (CE 3.5) on my
desktop. But my VS is using the old SQL-Server-Mobile 3.0. How can I choose,
which server version I want to use? Is the choosen version used on desktop
and also used on deployments to the mobile device?

2. I´m using the CE for some application also at my desktop. Both is working
fine, using mobile databases on the mobile device and using desktop-database
on the desktop computer. But now I need to access a database placed on
(connected) a mobile device from a desktop application. If I access this
database-file from the server-explorer it is working very fine. Also creating
a DataSet in VS from the mobile file is working nice - I can also access from
the Dataset the tables and make a sample query. But if I start my application
it says, that there couldn´t find the database file :(...

Thank you

Waldemar

Reply to this Message

ErikEJ - 13 Oct 2007 13:51 GMT

re 1: You should use Visual Studio SP1 with SQL Compact Edtion 3.1.
For detailed upgrade guide see
http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2
005-for-use-wtih-sql-server-2005-compact-edition.aspx

re 2: You cannot connect to a sdf file (database file) on your device from a
desktop app.
Your best bet is to use RAPI to copy the device database to your desktop PC.

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi to all!
>
[quoted text clipped - 25 lines]
>
> Waldemar

Reply to this Message

Waldemar - 13 Oct 2007 20:06 GMT

Thank you Erik for this nice answer.

1. I will read this :) I think this answers my question

> re 2: You cannot connect to a sdf file (database file) on your device from a
> desktop app.
> Your best bet is to use RAPI to copy the device database to your desktop PC.

2. But how do the Visual Studio do this? They make a connection string and
then they really connect every time to the database located on the mobile
device. And I do also think, that they do not do any copy, because my file is
slightly big (10 MB) and this takes normally some time to copy this from
mobile to my desktop

Thank you and have a nice weekend

Waldemar

Reply to this Message