Re: Local datastore for visual basic .net aplication on a pda

From: Chris Tacke, eMVP (ctacke_at_spamfree-opennetcf.org)
Date: 11/11/04


Date: Thu, 11 Nov 2004 08:00:02 -0500

Yes. And in that case it's also free.

-- 
<ctacke/>
www.OpenNETCF.org
Your CF searches start and end here
"Aaron" <ABieberitz@charter.net> wrote in message 
news:10p5t36s8u3g5e1@corp.supernews.com...
> In other words, if you don't need to sync your datastore with the desktop,
> or back your data up on the desktop in any way, SqlServerCe can be used
> without having SQL Server on the desktop?
>
> "Chris Tacke, eMVP" <ctacke@spamfree-opennetcf.org> wrote in message
> news:eujzIb5xEHA.4028@TK2MSFTNGP15.phx.gbl...
>> Sure.  SqlServerCe is what you want.  You don't need a backend server to
> use
>> it, it works fine as a local data store.
>>
>> -- 
>> <ctacke/>
>> www.OpenNETCF.org
>> Your CF searches start and end here
>>
>>
>> "Rui Guedes" <RuiGuedes@discussions.microsoft.com> wrote in message
>> news:3630BB66-3E4D-4535-AF4F-68849ADFCAE0@microsoft.com...
>> >I have this project for developing an  drug interaction aplication for a
>> >pda
>> > under a windows o.s .
>> >
>> > The aplication is being developed on visual basic .net (using visual
>> > studio
>> > .net 2003), and I needed to create an local datastore, the problem is
> that
>> > most of the database access controls and etc available on the full .net
>> > framework arenīt available for the .net compact framework, so, so much
> for
>> > using an MS access database file, as for SQL, I kinda dislike the ideia
> of
>> > having to install the CE server on the pda  just to run a lame database
>> > that
>> > only uses  SELECT and WHERE (=?) queries (the aplication only reads a
>> > specific value from a field on the database and compares it to another
>> > value
>> > from another field).
>> >
>> > So after all this, here's my questions: Is there any way to use an sql
>> > database file as an local datastore without the SQL server running? 
>> > Just
>> > by
>> > reading from the file that is? And how about an serialized xml file 
>> > from
>> > the
>> > object model, could it do the trick or  does it run in to the missing
>> > class
>> > prob in compact framework?
>> >
>> > Thanks for reading and for your time, help is most welcome.
>>
>>
>
> 


Relevant Pages

  • Re: Access DataBase on PocketPC
    ... remote SQL Server, it also allows access to data in XML text files. ... CE Databases from the .NET Compact Framework. ... Access database engine including long Binary fields. ... > connection with a access database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Driver caching db??
    ... The driver does not touch the database file directly. ... > Then I try to attach to the database in SQL Server Enterprise Manager ...
    (microsoft.public.sqlserver.odbc)
  • Re: Opening a SQL Server 2005 Database...
    ... *.mdf is not database, it is data file used by SQL Server/Express. ... The database file name only used in ConnectionString with "AttachDBFileName=..." ... I'm trying to open a SQL Server 2005 Database without creating a Data ...
    (microsoft.public.vsnet.general)
  • Re: Any Option to Save Changes to Database?
    ... If you don't see the database file being copied, ... "Jonathan Wood" wrote: ... It has nothing to do with SQL Server Express itself... ...
    (microsoft.public.dotnet.framework.adonet)
  • Multiple forms (advanced programming, I think)
    ... I am developing an application for Pocket PC 2003 with Visual Studio ... 2005, C #, Compact Framework 2.0 and SQL Server CE. ... depending on what is retrieved from the database. ...
    (microsoft.public.pocketpc.developer)