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

OK...let's get a couple of things cleared up here...there is not an OleDbDataSourceItem...when I posted this, I was alluding to the fact that you would be using a data source that using using the OleDbCommands.  SF comes with a base class called DbDataSourceItem.  There is not a generic OleDbDataSourceItem as each OleDbProvider may have different requirements and commands (such as Access and VFP).  But you can create your own very quickly.  Just open the SF source, and go to the Base assembly.  In that assembly there is a folder called Data\DataSourceClasses.  You will find all of the SF pre-plumbed data source classes there.  Just copy the Access or VFP source code and then go into your assembly and create your own data source item called WhateverDataSourceItem that is specific to the compact environment that you are trying to use.

Using SqlDataSourceItem on Embedded Editions
Now if I am not mistaken, if you are trying to use SQL Server Everywhere (or a compact edition of SQL Server) then you can use the SqlDataSourceItem and then specify the OLEDB provider or other supported SQL provider as part of your connection string and it will work just fine.  Ths SQLCommands should support the SQL Everywhere editions as I am pretty confident that this is the approach a number of our developers are using for this embedded data source.  But in the case that you are using something other than an SQL edition, then you will need to create the data source mentioned above.

This can also be impacted by the version of the Mobile SDK being used, etc.

Also, there is more than one way to connect to a Mobile version of SQL Server...you can use the SqlCeXXX commands and namespaces which would require you to create your own data source (mentioned above) or to use OLEDB or ODBC, which both of the latter mentioned should be able to use the standard SQLConnection and SQLCommand as well as the SqlDataSourceItem classes.

Finally, Keith, the DDT does not support a compact or embedded edition of SQL Server...this is a totally different platform and would require major changes to the DDT in order to work.

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).

Excellent, your your vacation was relaxing. Welcome back.

PS - Cowboys 21 - Eagles 30 Monday night

Keith Chisarik

copied file and renamed ...not sure what all changes need to be made as it looks very generic to any ole provider.

tried to rebuild microfour.strataframe base and got the following error...

Error 1 The command ""C:\Program Files\MicroFour\StrataFrame Source Code\MicroFour StrataFrame Base\AfterBuild.bat" "C:\Program Files\MicroFour\StrataFrame Source Code\MicroFour StrataFrame Base\bin\MicroFour StrataFrame Base.dll" "C:\Program Files\MicroFour\StrataFrame Source Code\MicroFour StrataFrame Base\bin\microfour strataframe base.xml"" exited with code 9009. microfour strataframe base

was i doing the right thing?

Hey Mike.

Try the following:

1. Close down all Visual Studio Instances
2. Open two Explorer Windows.  Navigate one to the "C:\Program Files\MicroFour\StrataFrame Source Code\MicroFour StrataFrame Base\bin" folder and the other to the "C:\Windows\Assembly" folder.
3. select the "MicroFour StrataFrame Base.dll" from the bin folder
4. Drag the selected file into the "c:\windows\assembly" folder (GAC)
5. Also copy the "MicroFour StrataFrame Base.dll" and the "microfour strataframe base.xml" to the "c:\program files\common files\microfour\strataframe" folder
6. Your assemblies will now be on the latest build.
7. Go back into Visual Studio

Well...you know, the other day Charles Hankey sent me something prior to the Browns game...and well, we know how that turned out.  So I will wait until next Tuesday before I say too much...but when the Boys win ... then I will have more to say

Oh...and Ivan's suggestions look good, Mike 

Thank you will try. 

Do you know if by getting that error that anything was rebuilt?  do i need to take out the post build event out to get it to rebuild successfully first?

Thanks again everyone!