Re: Database for a WM5 device

Peter,

Thanks for the help. I'm still a little confused, so hopefully you can
clarify.

It sounds like I can use SQL CE on my WM5 device. Currently I only need the
DB to reside on the device. Assuming that I have added all the proper
references and installed SQL Server CE on my desktop, should these two lines
of code work??

dim engine as New SqlCEEngine("Data Source = test.sdf")
engine.CreateDatabase()

From everything I have read, this should create a test.sdf file on my PPC,
which I can then issue other commands against in my code. However, the
..CreateDatabase line is generating an exception and I cannot figure out why.
I have found plenty of other posts on the WWW with this same problem, but not
a single one has a solution for this.

Do you think it is my configuration?? Again, I am using VS.NET 2003, CF1.1
and a WM5 device.

After downloading and running the setup for SQL CE from the Microsoft
website is there any further I need to do??

This problem is driving me nuts!!

Your help is appreciated,

Brian



"Peter Foot [MVP]" wrote:

SQL CE will work on WM5 and older Pocket PCs. However you can't create a SQL
CE database on the desktop (without third-party tools). SQL Mobile has tools
within VS2005 to support creating your database on the desktop, to use SQL
Mobile you need .NETCF v2.0 so this is only an option for PPC2003 and newer.

Peter

--
Peter Foot
Windows Embedded MVP
www.peterfoot.net | www.inthehand.com

"brianbulla@xxxxxxxxxxx" <brianbulla@xxxxxxxxxxx@discussions.microsoft.com>
wrote in message news:D06C5E68-7A1A-42E3-AD86-38ABAF95F386@xxxxxxxxxxxxxxxx
Hello,

I need a database for my WM5 app. I am using VS.NET 2003. I would like
to
use ADO style access to the database.

I noticed on my old PPC 2002 device that I could upload .mdb file to and
they would automatically be converted to .cdb. With WM5 this is no longer
possible due to the lack of Pocket Access.

Therefore, how do I build a database for my WM5 device?? Do I need to
upgrade to VS.NET 2005??

I tried installing SQL Server CE onto my desktop and then using the
'engine.createdatabase' method to create an .sdf file, but that generated
an
exception.

I am at a loss trying to figure this out. I thought it would be simple.

Any help is appreciated.

Thanks,

Brian



.

Relevant Pages

  • Re: Database for a WM5 device
    ... It sounds like I can use SQL CE on my WM5 device. ... .CreateDatabase line is generating an exception and I cannot figure out ... CE database on the desktop. ...
    (microsoft.public.pocketpc.developer)
  • Re: Help connecting to Access DB from web service
    ... I would love to move the database to SQL Express but that is not an option ... Given that I can not move the data to a better database, ... application that will also open and access the mdb file, if so, I'm ... appliation runs under the asp.net worker process (under the worker proces ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Database for a WM5 device
    ... You suggestion of the single quotes wasn't it. ... After doing that I am able to run my SQL CE commands in my VB.NET program ... It sounds like I can use SQL CE on my WM5 device. ... CE database on the desktop. ...
    (microsoft.public.pocketpc.developer)
  • Re: Back-to-front introduction needed
    ... >about database design principles. ... OK let me explain that naive question: If I think about the Access ... then is the database the .mdb file in an isolated sense or is it ... And then what about SQL, which I've little direct experience of? ...
    (microsoft.public.dotnet.framework.adonet)
  • Problem on installing SQL 2005 Mobile
    ... I encounter a problem on installation of SQL 2005 Mobile on a WM5 device, ... I installed the SQL Mobile Engine on the WM5 device without ...
    (microsoft.public.sqlserver.ce)
Loading