I am trying to access SQL Server data from an xda (Pocket PC). I have read various articles and had a play with Embedded VB. The articles I read all seem to point to running SQL Server CE and replicating data between this and my SQL Server using SOAP/XML.
Firstly, can I set up a VPN between the xda and our internal LAN (we have extensive knowledge of VPN but can't get it working on the xda)?
Secondly, if so, which data provider can I use? Running a test application in the Pocket PC Emulator keeps saying it can't find the provider SQLOLEDB. Is this installed with SQL CE? Will it allow me to directly access our main SQL Server or is it limited to SQL CE/Pocket Access?
I would prefer not to have to set up a web server for SOAP/XML, especially if I can establish a VPN.
Sorry if this is not very VB 5 & 6 related, but there's no more appropriate forum, you all seem such clever chaps (& chapesses) and I do occasionally answer the odd question or two ...
Firstly, can I set up a VPN between the xda and our internal LAN (we have extensive knowledge of VPN but can't get it working on the xda)?
Secondly, if so, which data provider can I use? Running a test application in the Pocket PC Emulator keeps saying it can't find the provider SQLOLEDB. Is this installed with SQL CE? Will it allow me to directly access our main SQL Server or is it limited to SQL CE/Pocket Access?
I would prefer not to have to set up a web server for SOAP/XML, especially if I can establish a VPN.
Sorry if this is not very VB 5 & 6 related, but there's no more appropriate forum, you all seem such clever chaps (& chapesses) and I do occasionally answer the odd question or two ...
