Re: local database
From: Ginny Caughey [MVP] (ginny.caughey.online_at_wasteworks.com)
Date: 12/06/04
- Next message: Stuart Celarier: "Re: Setting a LIstView as single select"
- Previous message: Zahid: "UDPClient.receive and network PORT issue?"
- In reply to: Andrea: "Re: local database"
- Next in thread: Rüdiger Kardel: "Re: local database"
- Messages sorted by: [ date ] [ thread ]
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, >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
- Next message: Stuart Celarier: "Re: Setting a LIstView as single select"
- Previous message: Zahid: "UDPClient.receive and network PORT issue?"
- In reply to: Andrea: "Re: local database"
- Next in thread: Rüdiger Kardel: "Re: local database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|