Connecting to a Access DB from a mobile device

I have a regular Access DB on a desktop PC, I am trying to retrieve data from it through a mobile device running Windows Mobile (both are on a network). I didn't have any luck so far. I'm doing this .net 2003. Any input would be greatly appreciated.


My 1st post BTW :) Until now I was able to find pretty much everything by searching.

I don't know much about .net ....

I take it that if you had the vb.net program on the desktop it connects ok?
I cannot see a problem otherwise apart from specifying the drive letter (if the mobile device acts lik a normal comp).

May be you need to use unc path or something to specify the connection.

If you find out or discover how to do this post back - I'd be interested in how you solved it. Also you may want to move/ask about connections in the .Net forum too?

Now when I think about it, you are right, this question would be better off in the .Net forum. Could a mod move it there please?

Moved to the (.Net) Mobile Development forum, which should get the best results for you.

Hi,
out of the box, .NET CF only supports connecting to SqlServer databases on the desktop, using the SqlClient namespace.

We have a product, SqlLinkCE at www.gui-innovations.com that supports accessing any ODBC compliant database from the PPC environment.

Pete

you could use a webservice to extract that data you need from the access database using odbc or oledb.

Then the device could retieve the data from the webservice and store locally on sqlce.