Re: local database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ginny Caughey [MVP] (ginny.caughey.online_at_wasteworks.com)
Date: 12/06/04


Date: Mon, 6 Dec 2004 08:17:39 -0500

Andrea,

I don't know if it is in your price range, but CodeBase (www.codebase.com)
should be able to do what you want.

-- 
Ginny Caughey
.Net Compact Framework MVP
"Andrea" <Andrea@nospam.it> wrote in message 
news:%23Y3zuQ22EHA.1564@TK2MSFTNGP09.phx.gbl...
> Yes, but I have the trouble of installing sql ce on the device (and also 
> provide some way for the user to re-install it, in case of completly power 
> loss or cold-boot).
> Another problem is that I would like to use the same database file for the 
> pc (a rewrite of the same pocket pc application, but used on a standard 
> laptop pc). Without using a server or iis on the laptop, and with the 
> minimum amount of configuration effort. I can do this with jet and 
> activesync, but when the pocket pc is out of office, they need to send 
> data via gprs, and activesync cannot convert the database (or there is a 
> way to convert a file already transferred on the pc ?).
>
> So, if exist, I really like some 'more easy' way to store and transfer 
> data... just a simple file, the only things I need is an index, because 
> lookup a record with a complete scan of a file (about 20.000 records) is 
> very time consuming...
> really there is no library like this on the net ? I have tried 
> codeproject, and sourgeforge, but found nothing ...
>
> Thanks in advance
> Andrea
>
>
> "Darren Shaffer" <darrenshaffer@discussions.microsoft.com> ha scritto nel 
> messaggio news:ev%23Kgbk2EHA.3000@TK2MSFTNGP15.phx.gbl...
>> How about using SQL CE only for local data persistence and using a 
>> replication
>> strategy to get your data to the server?  This can be done with RDA, 
>> Merge, or
>> your own web-services based strategy.
>>
>> -Darren
>>
>> "Andrea" <Andrea@nospam.it> wrote in message 
>> news:uMRBkoj2EHA.524@TK2MSFTNGP09.phx.gbl...
>>> This is the real dilemma ...
>>> I cannot use SQL CE because when the file is on the server I have no way 
>>> to manipulate it ...
>>> If you know of a third part managed library for NET Framework to access 
>>> SQL CE file (.sdf) ... please let me know ...
>>> but i think is an expansive solution ...
>>>
>>> Otherwise if someone know of somethings better than .xml or .cvs file to 
>>> store, transfer and manipulate data ... (but the amount of data is huge, 
>>> so I dont'like these 'flat file' solutions)
>>> I think the best way is a simply managed library, compatible with CF and 
>>> NET, that can handle a simple (1 table) database file with index... but 
>>> I have not found one on the web ...
>>>
>>> Best regards,
>>> Thanks in advance...
>>>
>>>
>>>
>>> "Darren Shaffer" <darrenshaffer@discussions.microsoft.com> ha scritto 
>>> nel messaggio news:uNDiOKj2EHA.1524@TK2MSFTNGP09.phx.gbl...
>>>> You can absolutely transfer a SQL CE 2.0 database file (*.sdf 
>>>> extension) from your device
>>>> to a server via WIFI or GPRS.  You can also pull a SQL CE database file
>>>> from a server to your device the same way.  The limitation is that 
>>>> you'll need
>>>> a third-party utility to access or modify the SQL CE file when it's on 
>>>> the server.
>>>>
>>>> With SQL Mobile coming out next year, this limitation goes away.
>>>>
>>>> -Darren Shaffer
>>>>
>>>> "Andrea" <Andrea@nospam.it> wrote in message 
>>>> news:OeDdAki2EHA.3120@TK2MSFTNGP12.phx.gbl...
>>>>>I need to have a local database on Pocket Pc.
>>>>> I dont' want to use SQLce or Jet, because I need to upload this file 
>>>>> (database) on a pc or a ftp server and I dont' want to use active sync 
>>>>> (I use direct lan connection to upload the file (Wi-Fi or GPRS)).
>>>>> I need also to download database from a web server to pocket pc.
>>>>> There is some library for Net that can handle a simple single file 
>>>>> database and that is binary compatible with CF and NET (possibly 
>>>>> opensource) ?
>>>>>
>>>>> Thanks in advance,
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> 


Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)