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

You will not want to use the Connection Wizard in this case.  You will need to manually supply the connection string.  The Connection Wizard only works with:

• SQL Server (no embedded editions)
• Oracle
• VFP
• Access

If you need to connection to a different type of OLE database, then that is fine and SF will work, but you will have to manually supply the connection string:

When you do this you will place this code in the Appmain.vb SetDataSourcesMethod and then remoce the SetConnections line (as this forces the Connection Manager to be used).  Also, there is a lot of information about connection strings and setting them up manually within the help docs as well.

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. 

I am also looking for OleDbDataSourceItem for use with SQL Compact 3.5 as discussed in this and other threads on the forum. I have a simple application that does not warrant SQL Express, I have used SQL Compact for mobile applications and would now like to use with SF for desktop.

Please point me in the right direction as I cannot find anything on this provider in SF help.

Keith Chisarik

An overview of how to deploy to SF Compact database (.sdf) from the DDT would be great too.

Keith Chisarik

I hope someone can help soon