Query SQL?

[Guest Dade]

If I was to use vb.net could I write and app that could query an sql database or would the be beyond the Smartphone platform?

[Guest ChrisJM]

this cannot be done with smartphone (AFAIK) :!:

[Guest Kingherc]

I get the feeling that this can be done with .net compact framework. I'm not sure if it can be done for sql databases, but i think you can query databases with an oledb connection (e.g. a database made with Microsoft Access). I haven't tried it on a smartphone. Try creating an access databse and then, in the program, create a oledbconnection, then an oledbcommand, then a datareader from it.

[Guest Peter Foot]

There is no OleDb provider for the .NET Compact Framework. If you want to get data off a remote server you have to implement your own method either using Sockets or Web Services etc

[Guest Brody]

It depends doesn't it guys? Surely you could query a remote database by parsing the query via GPRS? Just a thought...

[Guest ealimam]

Peter Foot is telling the truth. There are no class libraries built into .net compact framework to access data directly from a database using ado.net, oledb, odbc, etc. In order to access data from a database, you need to expose that data using alternatives methods. Exposing your data through a set of web services usually provides the best results (depending on your application needs, of course).

Microsoft completely screwed up on this one and trust me they are getting a ton of flak for it. I hope they get their act together and add direct database access support to their next release of the framework. Once can only hope. In the mean time, good luck!

Emory Al-Imam

[Guest ealimam]

Peter Foot is telling the truth. There are no class libraries built into .net compact framework to access data directly from a database using ado.net, oledb, odbc, etc. In order to access data from a database, you need to expose that data using alternatives methods. Exposing your data through a set of web services usually provides the best results (depending on your application needs, of course).

Microsoft completely screwed up on this one and trust me they are getting a ton of flak for it. I hope they get their act together and add direct database access support to their next release of the framework. Once can only hope. In the mean time, good luck!

Emory Al-Imam

[Guest ealimam]

Peter Foot is telling the truth. There are no class libraries built into .net compact framework to access data directly from a database using ado.net, oledb, odbc, etc. In order to access data from a database, you need to expose that data using alternatives methods. Exposing your data through a set of web services usually provides the best results (depending on your application needs, of course).

Microsoft completely screwed up on this one and trust me they are getting a ton of flak for it. I hope they get their act together and add direct database access support to their next release of the framework. Once can only hope. In the mean time, good luck!

Emory Al-Imam