How to connect to SQL database on a Windows CE Application for ARM

Question

I'm trying to send queries to a SQL database from a Windows CE 7 C++ application running on an ARM architecture.

During my research I found several possibilities to do this:

• Use methods from system.data.sqlclient Doesn't work, since the application is not supporting CLR

• Use ODBC or OLEDB I read at several points that both won't work on Windows CE

• Use HTTP requests from winInet to send the data as JSON to the DB and parse it back there Just an assumption that this could work, not confirmed

So I'm wondering what other/better ways there are to send these queries.

Thanks for your help!

Answer 1

you can implement your third option but you need to implement also another software component (on the SQL server side) to do the following work:

• connect to the database;
• decode the JSON and query the database;
• encode the database answer in JSON and send back to your WEC7 application.

If you are familiar with C# and if you have .NET compact framework installed on your WEC7 machine you could also implement the software component that will send HTTP REQUEST in plain C# (without the need to study wininet).

Hope this helps

Answer 2

If it is a pocket pc sql server lite database then you can use ADOCE to access and configure your database. The service'esqe approach is also valid and will take the data access burden from your client application.