CE app connecting to SQL Server 2000 on 802.11
Hi Bob,
Yes, it is possible to connect over 802.11b, as long as you have the network
drivers for your card
installed on your device and have TCP/IP going
(use a tool called vxUtil - http://www.cam.com/vxutil.html to test your
network connectivity).
Depending on what you want to do, may want to install SQLServer CE or not.
In most cases you need
to store some data on the device, so it would be good to have SQLServer CE
installed.
Then you can synchronize tables between SQLServer2000 and SQLServer CE
rather easily and also
execute commands on the SQL Server 2000 machine (Look at the
SSCE.RemoteDataAccess.2.0 object).
However, you can also use tools like PocketSOAP (www.pocketsoap.com) or
ViaDB and ViaXML (www.odysseysoftware.com)
to get to your data using a web service approach and then store the data on
the device in a CDB (PocketAccess) file
without having to install SQLServer CE.
I recently made the switch from PocketAccess to SQLServer CE and it is
definitely worth it, you get much more
functionality, more comprehensive SQL support and indexing, and speed.
Look at www.devbuzz.com for a number of great articles on this topic.
HTH,
Michael
Quote:
> Hi,
> Im pretty new to winCE and in the process of writing an
> app which is going to talk to SQL Server 2000 sitting on a
> W2K machine over Wireless(802.11b).
> Is it possible at all ? If Yes, do I need to have SQL
> Server CE installed on the device ?
> Are there any issues/should be aware of things/links
> towards it ?
> TIA,
> Bob
