Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

First App - SQL Server CE Problems

 
   PDA (Home) -> Pocket PC - Developer RSS
Next:  wm 6.2 n vc 1.6 bug  
Author Message
billbell52

External


Since: Aug 10, 2008
Posts: 3



(Msg. 1) Posted: Tue Dec 23, 2008 10:27 am
Post subject: First App - SQL Server CE Problems
Archived from groups: microsoft>public>pocketpc>developer (more info?)

I am doing my first demo app using VS2008 on Vista. I am having 2
problems.

Background:

The app uses SQL Server CE 3.5. I created an Access script to port an
Access db to SSCE (test.sdf). I create an Smartdevice app in VS2008
for Windows Mobile 6 Professional SDK and .NET Compact Framework 3.5.
I add a datasource to the project and enter the info for the SSCE db
and import the db. Everything works fine if the database is <
128Meg.

Problems:

1. I cannot import another db to the project. I tried to also import
Northwind.sdf and I get the error.

This operation requires a reference to SQL Server Compact 3.5. The
project has a reference to a different version. Update the reference
and try again.

I get the same error if I delete test.sdf and testDataSet.xsd and try
to add test.sdf again. This means if for any reason I need to re
import the db I need to create a new app. I tried to use SSCE SP1 and
the results are the same. In the project properties I tried setting
System.Data.SqlserverCE.dll Specific Version property to false. I
have not got far enough in the development to figure out how this
error impacts me.

2. If the test.sdf is large (400Mb) then I get an error about the db
being to larger. When I add the db I use the advanced options to set
the Max database size to 1024Mb. Here is the connect string.

Data Source=C:\userdata\ppc\test.sdf;Max Database Size=1024

Here is the error message:

The database file is larger than the configured maximum database size.
This setting takes effect on the first concurrent database connection
only....

I tried making a project with only this db and I still get this error
message in Server Explorer.

Any help is appreciated. It has got to be something I am doing
wrong. I cannot believe this would be released with such obvious
errors.
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Calendar Problems - Any time I add a Calendar entry through the client, it does not show on my mobile device after I sync with the exchange server. The syncronization sees the new item and seems to be syncing but cannot see any recurrring items or any new items in my..

OpenNETCF 1.4 problems - I've put the OpenNETCF 1.4 source into a solution so I could run it some in debug mode to check it out, but I am getting 463 build errors when I try to build OpenNETCF.Net, most of which begin with "Missing XML comment for publicly visible type o...

problems with CreateWindow - Hi, when calling CreateWindow, it returns with NULL, no window created. Also, the Window procedure (declared in the Register function) isnīt called before ! HINSTANCE hinst = GetModuleHandle(NULL); hwnd = ::CreateWindow(TEXT("testclass"), ...

Problems with an eventhandler - I have a very strange problem - it only occurs with CF 2.0 and one particular PDA (from TDS Recon). I kept getting a "native error", which I eventually tracked down to an "access denied" error. This appears to happen when the program ...

Obex Server - Hello, I need to develop my own obex server over bluetooth using normal socket communication for windows mobile 5.0 device. Now there is a default obex server already running on the device, i need to disable this and get all the obex requests in my..
       PDA (Home) -> Pocket PC - Developer All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
 Mac Forums
  PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact