Jump to content

Query SQL?


Guest Dade

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.