Connecting with access database in Net Compact Framework application

[pawera]

Hi Everybody !

I`ve got a problem with developing application which is to be run on
PDA (MIO A701 with WIndows Mobile 5).
I`m trying to create application in Visual Basic NET using NET
Compact
Framework.
This will be very simple database application using Access Database.
Unfortunatelly I can`t use class OleDbConnection and app is not able
to connect with my mdb.


Still problems on this stage
Dim con As OleDbConnection = New OleDbConnection(conString).


What to do?


Does Net Compact Framework work with Access Databases?
If yes then how to change above code but if it doesn`t the what
database should I use so that I can still have available my data on
PDA. This application can`t connect with internet etc. then Ms SQL is
no good


Thanks for respones

 

[Guest]

No, Access is not a supported database for the Compact Framework. Use SQL
CE.

 

[pawera]

No, Access is not a supported database for the Compact Framework. Use SQL
CE.

--

Chris Tacke, eMVP
Join the Embedded Developer Communityhttp://community.opennetcf.com











- Poka¿ cytowany tekst -

Ok. thanks for reply.

The I`ve one question more.
in case of using SQL CE would it be possible to hold all my data
localy on my PDA ?

 

[Delicioustian]

Yes~
Everything could be done locally in your PDA



<[email protected]> ????

No, Access is not a supported database for the Compact Framework. Use SQL
CE.

--

Chris Tacke, eMVP
Join the Embedded Developer Communityhttp://community.opennetcf.com











- Poka¿ cytowany tekst -

Ok. thanks for reply.

The I`ve one question more.
in case of using SQL CE would it be possible to hold all my data
localy on my PDA ?