Connecting to a Access DB from a mobile device

[Merso]

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.

[Ecniv]

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?

[Merso]

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?

[si_the_geek]

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

[petevick]

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

[Strider]

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.