Pete Vickers shows us another alternative for remote data access; ”There are a couple of options for remote database access from the Pocket PC, but with my interest in TCP/IP, I decided to investigate a 'roll your own' solution. The basis for the design is a data server on the PC, a client on the Pocket PC, and our old friend the Winsock control - in spite of its well known problems on the Pocket PC. The client will pass requests to the server, the server will carry out the request and return the results to the client. True Client/Server computing, and remote data access.”
Need to access remote databases from eVB? Shakil shows how it is done using XML; "This article is based on one of many experimental things I do when I am bored. The concept is pretty simple. I wanted my eVB application to talk to MS SQL Sever 7 over the TCP/IP network, just the kind of the thing I do with my desktop database applications. I couldn't find any SQL Server ODBC driver for WinCE, and was not interested in writing one. But I could find different ways to connect my WinCE device to a TCP/IP based network. So I went for a different approach..."
One disappointing aspect of using ActiveSync's Pocket Access conversion utility is that queries stored in the desktop version of an Access database are not converted. In this article Jim Poe shows us how to use the CDB system table MSysProcs to store SQL procedures.
One of the most frustrating issues is accessing a database in emulation, especially if you have just designed it in Access.
This brief article demonstrates how to create a bookmark in an ADOCE recordset using eVB.