conneting to a database on a pocket pc

[Alfonso Paredes]

I want to read and write to an access database on a
pocket pc.
In a desktop environment you use the System.Data.OleDB
namespace and all the objects in there. i.e.
OleDbConnection, OleDBCommand, etc.

But in the compact framework none of those exist. So the
question is which classes should I use instead of
OleDbConnection, OleDbCommand and OleDbDataReader?

Saludos

Alfonso

 

[Michael Lang]

What DB are you using? I noticed the Sql provider is available on the .NET
compact framework.

Here's how to get Sql Server for Windows CE:
http://search.microsoft.com/search/results.aspx?View=msdn&st=a&qu=SQl+Server+windows+CE&c=4&s=2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_overview.asp

 

[William Ryan]

Using pocket access is a total pain in the butt on the cf
because there isn't support for it in ADO.NET. You can
write stuff to xml using dataset.writexml and then
readxml or use SqlServerCE as mentioned in Michael's
post. Done both of these and they are fairly simple to
implement.

If you look at the cf forum on www.devbuzz.com I have a
few posts about it.

Good Luck,

Bill

W.G. Ryan
(e-mail address removed)
www.knowdotnet.com