[dba-SQLServer]SQL Server CE 2.0

MartyConnelly martyconnelly at shaw.ca
Thu Sep 18 12:57:28 CDT 2003


When MS first set the software up for PDA's, a big PDA might have 4Meg 
and run at $1500. Could be why they passed on Access too.
You have to first figure out if he is going to have PDA's with wireless 
communications.
With Mobile access to PDA's through dotNet you could also send the data 
and forms to things like Blackberrys or Nokia phones. I did something 
similar using a WAP server to send Access mdb data to a Blackberry. I 
used a free WAP server at www.tagtag.com that ran ASP code to get the 
data from a remote ASP site that queried the mdb file and then generated 
the WML to the blackberry but dot net might more advanced. You have 
problems with 23 line screens etc.
 you might want to haunt the http://www.gotdotnet.com mobile forums for 
more uptodate advice.

MartyConnelly wrote:

> It is easy to get at a database with forms if you have a wireless 
> modem, if you don't, you would have to use something like AppForge's 
> VB forms with a PDB database which is essentially simple tables.
> http://www.appforge.com
>
> No way to install Access on the PDA, but with a wireless modem all 
> sorts of options open up via the net. There is no Mobile Access 
> probably due to RAM restrictions. I haven't messed about with SQL 
> server CE.
> .
> Or you if you need a small footprint database and ODBC depending on 
> your PDA ram try
> CodeBase for Windows CE with VB
> http://www.sequiter.com/products/windows_ce/
> I have used CodeBase years ago with C and DOS.
>
>
> Steven W. Erbach wrote:
>
>> Marty,
>>
>> I really appreciate your response on this. I want to be sure that I 
>> make my
>> goal clear, though. The ideal situation would be to use one of these 
>> Windows
>> enabled hand-helds with Microsoft Access. When I perused the Windows 
>> Mobile
>> web site I saw references to Mobile Word and Mobile Excel...but nothing
>> about Mobile Access. It seems that it doesn't exist or isn't 
>> implemented. Am
>> I correct in deducing that?
>>
>> If it's indeed the case that Access isn't available on these CE / Mobile
>> devices, then I'm a bit up the creek since I don't think my client 
>> wants to
>> pay me to learn .Net or Java. That's why I mentioned a DOS emulator and
>> Paradox for DOS or dBASE.
>>
>> I looked at the features of Mobile Windows for hand-helds and I saw 
>> quite a
>> bit on e-mail and a tiny IE and games and phone books...but not much (at
>> least on the Microsoft site) on real-live business applications like
>> shipping and receiving.
>>
>> I suppose that this isn't a strictly SQL topic, but that reference to 
>> SQL
>> Server CE kinda threw me. If one is going to use SQL Server CE then 
>> one must
>> have a SQL Server CE box. Then one can replicate data back and forth 
>> from
>> handhelds, right?
>>
>> Regards...
>>                 `·.¸¸.·´¯`·.¸¸.·´¯`·->  Steve Erbach
>>
>>
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>>
>>  
>>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list