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

I'm sure someone will be along shortly with the magic answer. Hopefully like Greg said it is just an assembly we are missing (I hope). I am excited to get my new project working using compact databases, it will make deployment much easier for a relatively simple product.

The fact that Trent posted to use the OLE provider, with source code above, makes me feel good about a quick resolution.

Keith Chisarik