SQLMobile Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with VS2005 beta 2. I want to put together a mobile application
using a SQLMobile database. The server application has all the data stored
in Oracle tables. Can I write a vb full framework application that will
write records in a SQLMobile database? If, not what is the best way to
populate my data with out having to create a Sql Server database?
 
Brian,

You won't be able to write a production desktop VB.Net app that uses SQL
Mobile unless the "desktop" is a TabletPC. Since you don't want to create a
SQL Server database as an intermediate step, your choices are XML (bulky and
slow), CSV (less bulky and twice as fast as XML - see www.opennetcf.org
TextDataAdapter), or write a desktop web service to provide data services to
your mobile app.

Ginny Caughey
..NET Compact Framework MVP
 
I have this working, although I'm not happy with the solution. You can
get it to run on the desktop on a machine with Beta 2 installed.
 
Damon,

Yes you can. In fact the SQL Mobile Books Online even explains how to do it.
But I don't think this will be an approach within the licensed usage of SQL
Mobile from what I understand.

Ginny
 
Ginny, are you saying that for licensing reasons we can create and populate
SqlMobile databases on desktop just from SqlServer or VS2005 but we can't
create it from an our .net application? I can't create from my application
on desktop an sdf in batch, so I have just to transfer the sdf to the mobile
device?

Why do you think this...is it written somewhere?
 
Stefano,

I am at TechEd in Orlando, and I will try to get a definitive answer for
you.

Ginny
 
Stefano,

SQL Mobile is only supported on TabletPCs for production desktop apps. So
unless your "desktop" is really a Tablet, you won't be able to create SDF
files from your desktop app for production use. If this isn't what you want,
then you and everybody else who feels that way should make your opinions
known at Product Feedback:
http://lab.msdn.microsoft.com/productfeedback/default.aspx

Ginny
 
Back
Top