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

Could you give me an example of what exactly i need to do Trent?  Sorry for the confusion.

Try this link. It provides examples of valid connection strings for SQL Server embedded edition.



http://www.connectionstrings.com/?carrier=sqlserver2005ce



You'd just plug the appropriate connection string into the line of code Trent provided:







Replace "My ConnectionString" with the connection string you actually want to use.



This setups a default data source with a key of "" (empty string, the default used for BOs). This goes in the SetDataSources method in AppMain.vb or program.cs (VB or C# respectively).

here is what i am doing in appmain.vb...in the SetDataSources method i have the following code:

MicroFour.StrataFrame.Data.DataBasics.DataSources.Add(New OleDbDataSourceItem("PREMFRAME", "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\Users\michthom\Documents\Visual Studio 2008\Projects\premframev2\premframev2\premdatav2.sdf;"))

it tells me that OleDbDataSourceItem is not defined

i know i am missing something here.

I just searched through the object browser and I don't find this object....only datasourceitems for access, sql, oracle and vfp. That is strange. Is this in some other dll that isn't usually referenced? I also don't find anything about it in help.

Thanks.  I hope Trent can clarify for us.