Pocket PC Networking, eVC newbie : Connecting to a remote database

microsoft.public.pocketpc.developer.networking - this forum explains how the Pocket PC communicates with the Internet, with other mobile devices, and with networks. It teaches students the basics of Pocket PC telephony, synchronization, and messaging


Pocket PC Networking >> eVC newbie : Connecting to a remote database

by zardoz » Wed, 13 Jul 2005 21:47:31 GMT

Hello all,

My boss is suggesting that I write a program to connect my handheld
(WinCE4.2) to a database running on a server somewhere. Dunno what sort
of server or what db, but all our experience in house is with Oracle
running on Windows servers.

I've seen a few examples of ADO classes for WinCE on the net - I
suspect I can connect ADO to an ODBC database and that can all happen
across a wireless LAN?

Cheers for some suggestions.


Top

Pocket PC Networking >> eVC newbie : Connecting to a remote database

by Marius Prisecaru » Thu, 14 Jul 2005 04:35:30 GMT


Hi,




You mentioned CE 4.2 and eVC. ADO is not supported for v4+ C++ developers.
What you want to do is look into OLE DB. The database server could be SQL
Server 2K which would allow you to also install the SQL Server 2K Windows CE
Edition. Then, you could either use RDA or Merge Replication to synchronize
your data from your device to the SQL Server 2K central server. The way this
works is that it involves IIS to answer requests from the device to the
central server (therefore, it is through HTTP) so connectivity shouldn't be
a problem for most firewalls. Specifically, IIS behaves as a "middle man";
it responds to requests; it can forward for example a request of the device
to update something in the central server's database. Read about "SQL Server
2000 Windows CE Edition", about how the "agents" work, the ISAPI dll, IIS
and replication.

Marius




Top
Similar Threads

1. Remote Tool won't connect (newbie) 

I've got a device behaving strangely and I thought I'd use 
the remote tools from eVC4 to look at it.  Installed eVC4, 
and I've been trying to create a platform manager profile 
that will let me access my iPAQ 3950 device over 
ActiveSync.  When I choose ACtiveSync as both my Transport 
and Startup Server, I get:

"The Microsoft ActiveSync reported the following error: 
Unable to load device side components. Please check server 
configuration settings."

I've done all my PPC development using Appforge's 
MobileVB, and I'm at a loss.  ActiveSync 3.7 works 
correctly with the device, both over USB and COM1.  No 
other combination of transport & server works either.  To 
get the ACtivesync option, I do need to create a device 
under the Windows CE .NET Default Platform node, and I 
know this device is a Pocket PC 2002 OS, not a .NET OS.  
If that's the problem, how can I run remote tools on it?

Thanks for any help.

Brian Schuth
email:  XXXX@XXXXX.COM

2. Mount a Remote Hosted Database Over the Internet - Newbie

3. Connecting to remote fox databases over the internet 

Hello:

I am working in Fox9.  I have a remote computer running Win2003 Server / 
IIS6.0.  The remote computer has a foxpro database for data storage.  I have 
installed the OLEDB driver for Fox on the remote server.  What is the best 
technology to use to do database work over the internet?  I have looked at 
RDO (remote data objects) is that the reccomended method? or is there 
somthing newer/better.

Peter

4. Can't get ASP on remote sit to connect to Database on same site

5. WMP10 newbie question - remote control 

Here is a question that I cant find a straight answer to. I have always
admired the Sonos wireless MP3 network playing kit and have wondered
about setting up a cheaper alternative solution.

I've got a home wireless network and a WinXP PC with a huge MP3
collection. It has WMP10 installed. ( I could install Win Media Center
Edition on a PC if this helped the solution ).

My question: If I bought a PDA - say a Dell Axim - could I use it to
control what the PC played? I guess using VNC this is possible - but
does WMP10 have this function built in? Would I be able to select
albums, playlists etc and see coverart from the PDA?

I don't want to move any MP3s to the PDA, and want to use the PC
soundcard as the output.

The Sonos remote would do this as I moved about the house, but surely a
PDA with WiFi could do the same and should have the same attractive and
easy to use features? And obviously it can be used for many other uses
too.

Regards

Rob

6. Newbie to database learning

7. eVC++ newbie (from eVB !) 

Hi all

With all the probs i'm having with eVB i'm biting the bullet and taking a
look at eVC via a SAMS book for 'full' VC++. I know it's going to be a bit
up hills but i'm hoping future problems will be because of my knowledge
limits (solveable) and not the limits of the language (a bit more difficult
to solve) !

I'm just having a play and wondered how you change the background colour of
objects on a dialog app

My eVB app that i'm 'ultimatly' trying to convert has a green background to
the form with grey buttons.

I magaed to find the SetDialogBkColor() and put it in InitInstance which
works OK but I need to change the colours of individual controls.

Also my eVB app has 'Next' buttons which does "Form2.Show,Form1.Hide" etc I
presume I will eventually be able todo this sort of thing in eVC ?

Thanks in advnace

Andrew Kennard

8. newbie - OS Support for eVC 4.0 - Pocketpc Developer