VB.Net + mdb-Databases (Access) on WM6

[scilor]

How can I open Access Databases in VB.Net for WM6?

I want to use sql-commands to read, edit and write to the database

is this possible? thank you for help!

greetz SciLor

[LordDeath]

Ok, I have no idea about these things but I will still try it ;)
Maybe this?
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=38ed2670-a70a-43b3-87f3-7ab67b56cbf2

[scilor]

Thank you that might be what i search :D know i need to know how to access on on the DLL's :)

[Rudegar]

i do not believe that compact framework differs from normal .net
when it comes to oleDB interface
i would check out
codeguru.com for code about conecting to an access db

[scilor]

Thank you for the site! very useful

I will try to find something, but my problem is i never used vb.net in connection with databases

[Rudegar]

i cant help you with anything vb related as i hate vb
but if you need a connection string
http://www.connectionstrings.com/

[scilor]

I only read about sdf files... these databases suck, i dont want to work with different file types on my computer and my phone

[larryg4]

i'm using SQLite on my wharehouse program it's free fast and your database file is portable meaning you can access the data on your mobile as well as your destop, if you are coding in .net there is a net wrapper availiable too, you can connect with the database similar way as if it was sqlce database so i found it pretty easy, and the sql syntax is like typical SQL. you have to get a query analyzer separetaly though, or build your own it's not hard to implement.
So try Googling for SQLite and the .Net Wrapper basicaly you need only the Wrapper, and copy the wrapper .dll to your device in your app directory.

Ps. There are many open source projects availiable to learn how to use it just search

Ps2.Sorry for my bad english.