E
Evan Kontos
I need to be able to access an MS Access w/VB .net. Is there a good way
to do this?
to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tim Wilson
The CF does not contain direct support for accessing "pocket access"
databases. However, you can find a third party component that will allow you
to do this.
http://www.inthehand.com/index.php?page=5&show=1,2
databases. However, you can find a third party component that will allow you
to do this.
http://www.inthehand.com/index.php?page=5&show=1,2
W
William Ryan eMVP
Check out ADOCE by Peter Foot at www.inthehand.com - For what it's worth,
I've used it personally and was very happy with it. I also help run a
Compact Framework site and every bit of feedback that I've ever recieved
about InTheHand products has been very very positive.
Good Luck,
Bill
I've used it personally and was very happy with it. I also help run a
Compact Framework site and every bit of feedback that I've ever recieved
about InTheHand products has been very very positive.
Good Luck,
Bill
E
Evan Kontos
Is there a way to do it via XML or SQL and get the data back into
Access?
Access?
T
Tim Wilson
You mean XML or SQL CE on the device and an Access Db on the Server? One way
to do this would be to use a Web Service to handle the translation at the
Server end. So the device sends the data up through a Web Service call to
the Server and the Web Service would be responsible for sending the received
data to the Access Db, or anywhere that it might need to go. With this
method you could change the back-end database on the Server to any type of
data store as long as the Web Service knows how to translate what is sent
from the device into the format that it's stored on the Server.
Is this something that sounds like it would work in your situation?
to do this would be to use a Web Service to handle the translation at the
Server end. So the device sends the data up through a Web Service call to
the Server and the Web Service would be responsible for sending the received
data to the Access Db, or anywhere that it might need to go. With this
method you could change the back-end database on the Server to any type of
data store as long as the Web Service knows how to translate what is sent
from the device into the format that it's stored on the Server.
Is this something that sounds like it would work in your situation?
E
Evan Kontos
If that is the only way to do it w/o having to buy and use 3rd party
tools then that would be fine. Now you mention a web service running on
the server. The access database is residing on a file server someplace
but I don't think I will be able to run anything on the server itself.
Can the service run on the client workstation that is running
Activesync?
tools then that would be fine. Now you mention a web service running on
the server. The access database is residing on a file server someplace
but I don't think I will be able to run anything on the server itself.
Can the service run on the client workstation that is running
Activesync?
T
Tim Wilson
As long as you have a web server running (something like IIS) on a computer
that can expose the Web Service then you should be able to connect and
upload/download data via a method call (the Web Service call).
that can expose the Web Service then you should be able to connect and
upload/download data via a method call (the Web Service call).
E
Evan Kontos
Is there a way to do it with a manual process? Can I run an app on the
PC that will upload and download the file?
PC that will upload and download the file?
T
Tim Wilson
If you just need to do a straight file copy then an option might be to have
the desktop application utilize RAPI to connect to the device and
upload/download the file.
If this sounds like a good option then you should look into the
OpenNETCF.Desktop.Communication.RAPI class as part of the SDF.
http://www.opennetcf.org/sdf/
You might find some more help in the following thread for RAPI.
http://www.opennetcf.org/Forums/topic.asp?TOPIC_ID=122
Aside from that, I suppose you could make raw socket calls (TcpClient and
TcpListener) and send the data back and forth that way. This way would most
likely not be pretty though.
the desktop application utilize RAPI to connect to the device and
upload/download the file.
If this sounds like a good option then you should look into the
OpenNETCF.Desktop.Communication.RAPI class as part of the SDF.
http://www.opennetcf.org/sdf/
You might find some more help in the following thread for RAPI.
http://www.opennetcf.org/Forums/topic.asp?TOPIC_ID=122
Aside from that, I suppose you could make raw socket calls (TcpClient and
TcpListener) and send the data back and forth that way. This way would most
likely not be pretty though.
T
Tim Wilson
Sorry. The Desktop Communication Library is not part of the SDF. You can get
it at the link below.
http://www.opennetcf.org/PermaLink.aspx?guid=d7b7cbef-4ab6-477b-924c-0498a523beaf
it at the link below.
http://www.opennetcf.org/PermaLink.aspx?guid=d7b7cbef-4ab6-477b-924c-0498a523beaf
C