i am using sql server ce 3.5  my oledb provider is Microsoft.SQLSERVER.CE.OLEDB.3.5.  how do i modify appmain.vb to use this?  i don't think the connection wizard handles this but i could be wrong.  can someone step this beginner through whats necessary to hook my app up to the compact edition? 

Thanks in advance!

Mike

OK I hope the SQL data source will work, I wrote a MYSQL provider for my last project and really want to avoid ever going it again. It works but was a real pain.

As far as the DDT goes thats fine, I'll do what I did for the MYSQL provider, create a SQL Server mirror of the database just for BO Mapper.

Is adding official support for SQL Compact on the radar?

Thank you for your answers.

Keith Chisarik

Yes...but it is a very faint blimp   There are a number of other more highly demanded things ahead of this...so though this is something that will definitely be part of the framework, it may be a while.  Probably the next major release (SF 2.0).