I'm trying to determine what is and isn't possible before starting development of a mobile application for this mobile device (http://www.intermec.com/eprise/main/GSS/Service/Content/Tools/Tools_ListProductManual section=Tools&Category=CMPTR&Family=CMPTR2&Product=CMPTRCN2B&Tool=Manual&Language=English)
The current plan is to have a laptop acting as a central server and 2 handheld devices. On the laptop will be an Access database. The devices (barcode scanners) would be connected through wifi to the laptop. Would I be able to create a C# application on the mobile device that can pass the read barcode to a query to the Access database on the laptop through the wifi connection Or what would need to be done to enable it Can I just use a standard OleDbConnection and OleDbCommand from the device or is that not available on the device
Thanks
MS Access query from Mobile App
C#Student
Pockey
I'm, not quite sure what you mean by "what all works with the SQL clients or connections available in the NETCF". SQL Client is certainly available for NETCF if that’s what you asking.
SQL CE is also in process database, it does not allow for remote connections, not without proxies anyway. However, it is common to use SQL CE on devices for offline storage (so devices would work even if connection to the database is not available) and synchronize with database on the server from time to time.
Martin Saumann
You can not use OleDbConnection since it's not available on NETCF. In theory you could use COM interop to talk to OLEDB, but you would need JET/Access remote OLEDB driver for CE and I don’t believe there’s one.
Not to mention JET/Access is generally in process database and is not accessible remotely without some proxies or remote drivers. Consider ditching JET/Access and use, say, SQL Express instead. It has native support for remote connections and works with SQL Client available for NETCF.
KathyGirl
Thanks for the response. Is there any place to to find out what all works with the SQL clients or connections available in the NETCF I'm trying to find it on MSDN, but can't find any common area for NETCF.
It sounds like SQL Express might work, any idea about SQL Compact Edition