How can J2ME on a Series 40 device connect to SQL Server? Via a WCF service?
I am developing a J2ME app for a Nokia Series 40 device. I wish to connect to a SQL Server to read and write small amounts of data.
1. Can this connection be done via a WCF service?
2. If Yes, is there a sample or guide anywhere?
3. If No, what the recommended alternative architecture to connect to SQL Server?
Re: How can J2ME on a Series 40 device connect to SQL Server? Via a WCF service?
Use HTTP requests with XML or JSON data (for security reasons, you wouldn't want to send actual SQL requests for the server to execute), and write also the server-side app to process the HTTP requests, access the database and return the results. That way, you also isolate the client app and the "wire protocol" from the backend database implementation.