tag:blogger.com,1999:blog-5238131531249720750.post1952216471826942100..comments2024-01-22T04:58:27.847+01:00Comments on Everything SQL Server Compact: SQL Server Compact 4.0 SP1 CTP1 availableErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5238131531249720750.post-88122566153719874212012-08-16T18:17:54.926+02:002012-08-16T18:17:54.926+02:00Jamome: 1: 15th august 2012, released with VS 2012...Jamome: 1: 15th august 2012, released with VS 2012, 2: Not a clue, I do mainly .NET Dev, no C++ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-55284941045026642922012-08-15T19:00:21.376+02:002012-08-15T19:00:21.376+02:00Hi Erik,
First, thanks for your blog and toolbox ...Hi Erik,<br /><br />First, thanks for your blog and toolbox - you're providing much more dev support on SQLCE than Microsoft!!<br /><br />I have two questions:<br />1) Do you know of the release ETA of SQLCE4.0 SP1 (when it comes out of beta?)<br />2) I am using C++/MFC - Does CompactDatabase work differently in 4.0? It worked find in 3.5, but since moving my code to 4.0 I cannot get that call to work (and ISSCEError get_Description returns an empty string).<br /><br />Thanks again,<br />Jared<br />jamomehttps://www.blogger.com/profile/13005829610334750277noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-21761024059047848762012-05-09T07:31:21.958+02:002012-05-09T07:31:21.958+02:00Is this the same Medium Trust problem that require...Is this the same Medium Trust problem that required us to copy System.Data.SqlServerCe.dll from the 4.0 Desktop folder rather than using NuGet? I was hoping that would be solved.John WS Marvinhttps://www.blogger.com/profile/08890959778069788337noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-74862626388570253802012-03-09T08:19:00.312+01:002012-03-09T08:19:00.312+01:00Felipe - what errors are you getting...Felipe - what errors are you getting...ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-34426944745371002032012-03-09T00:09:11.921+01:002012-03-09T00:09:11.921+01:00The nuget package don´t work at Medium Trust! You ...The nuget package don´t work at Medium Trust! You need to rollback the version to 4.0.0.0.Felipe Fujiy Pessotohttps://www.blogger.com/profile/03960993986859299130noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-2038293486654392562012-03-07T17:38:48.579+01:002012-03-07T17:38:48.579+01:00Suggest you ask on Stackoverflow or MSDN, and plea...Suggest you ask on Stackoverflow or MSDN, and please provide more information, like type of project, your config file settings etc.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-24723651319616769692012-03-07T16:26:14.742+01:002012-03-07T16:26:14.742+01:00I'm getting this error when trying to add a co...I'm getting this error when trying to add a controller with an EF template. I've started with a new project and installed the packages. I've tried uninstalling/reinstalling SQL Server Compact 4.0 SP1 CTP1. The app runs and uses the 4.0 membership database ok. I can also use the Sql Compact Toolkit.<br /><br />Exception Type: System.Data.SqlServerCe.SqlCeException<br />Exception Message: Native components of SQL Server Compact engine are not loaded. Please reinstall Microsoft SQL Server Compact.<br />Exception Stack Trace: at System.Data.SqlServerCe.NativeMethods.ThrowIfNativeLibraryNotLoaded()<br /> at System.Data.SqlServerCe.SqlCeConnection.Dispose(Boolean disposing)<br /> at System.Data.SqlServerCe.SqlCeConnection.Finalize()<br /><br /><br />-------------------------<br /><br />Installed Extensions<br /> DevExpress Tools<br /> State = Enabled<br /> Version = 10.2.5<br /><br /> NuGet Package Manager<br /> State = Enabled<br /> Version = 1.6.21215.9133<br /><br /> WoVS Default Browser Switcher<br /> State = Enabled<br /> Version = 0.8.9<br /><br /> VSCommands 2010<br /> State = Enabled<br /> Version = 3.8.0.6<br /><br /> SQL Server Compact Toolbox<br /> State = Enabled<br /> Version = 2.6.2.1<br /><br /> Crypto Obfuscator Add-in<br /> State = Enabled<br /> Version = 3.0<br /><br /> Entity Framework Power Tools CTP1<br /> State = Enabled<br /> Version = 0.5.0.0<br /><br /> Productivity Power Tools<br /> State = Enabled<br /> Version = 10.0.20626.18<br /><br /> WPF About Box (VB)<br /> State = Enabled<br /> Version = 0.5<br /><br /> Indent Guides<br /> State = Enabled<br /> Version = 11.0<br /><br /><br /><br />-------------------------<br /><br />Environment Data<br />VisualStudio.Version = 10.0<br />VisualStudio.Edition = Ultimate<br />VisualStudio.FullName = C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe<br />VisualStudio.RegistryRoot = Software\Microsoft\VisualStudio\10.0<br />VisualStudio.LocaleId = 1033<br />VisualStudio.DisplayMode = vsDisplayMDITabs<br />Time.UTC = 3/7/2012 3:05:00 PM<br />Time.Local = 3/7/2012 7:05:00 AM<br />OS.Architecture = AMD64<br />Environment.Version = 4.0.30319.17379<br />Environment.HasShutdownStarted = False<br />Environment.OSVersion.Platform = Win32NT<br />Environment.OSVersion = 6.1.7601.65536<br />CurrentThread.Id = 1<br />CurrentThread.Name = [null]<br />CurrentThread.ThreadState = Background, WaitSleepJoin<br />CurrentThread.IsBackground = True<br />CurrentThread.UICulture = English (United States)<br />CurrentThread.Culture = English (United States)<br />Process.PagedMemorySizeMB = 349.40234375<br />Process.MaxWorkingSetMB = 1.34765625<br />Process.NonpagedSystemMemorySizeMB = 0.218002319335938<br />Process.PagedSystemMemorySizeMB = 1.37675476074219<br />Process.PrivateMemorySizeMB = 349.40234375<br />Process.VirtualMemorySizeMB = 985.390625<br />Process.WorkingSetMB = 441.21484375<br />Process.UpTime = 00:01:15.7154308Roarkhttps://www.blogger.com/profile/16132066460448013041noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-76409959365522772742012-03-06T19:16:51.565+01:002012-03-06T19:16:51.565+01:00You can use my command line query utility: sqlcecm...You can use my command line query utility: sqlcecmd40.exe, available from http://sqlcecmd.codeplex.comErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-9414653401071832492012-03-06T13:08:46.735+01:002012-03-06T13:08:46.735+01:00Hi ErikEJ,
The problem I encountered is that I us...Hi ErikEJ,<br /><br />The problem I encountered is that I used your toolbox export CE4 DB (data and schema) to files, but I found nowhere to import to,say, another CE4 DB.<br />For CE3.5, SQL 08 R2 SSMS can execute each generated file, (13 files, size around 240MB), into another CE4 DB (that's what I could think of for importing), the execution is pretty fast.<br />I read your blog and knew that MS SQL 08 R2 SSMS doesn't support CE4.0. And I used your toolbox to execute those files, much slower than SSMS. Any idea?<br /><br />Thanks!二百五https://www.blogger.com/profile/11067198099350492122noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-8929777546677108102012-03-06T12:26:59.920+01:002012-03-06T12:26:59.920+01:00Hi ErikEJ,
The problem I encountered is that I us...Hi ErikEJ,<br /><br />The problem I encountered is that I used your toolbox export CE4 DB (data and schema) to files, but I found nowhere to import to,say, another CE4 DB.<br />For CE3.5, SQL 08 R2 SSMS can execute each generated file, (13 files, size around 240MB), into another CE4 DB (that's what I could think of for importing), the execution is pretty fast.<br />I read your blog and knew that MS SQL 08 R2 SSMS doesn't support CE4.0. And I used your toolbox to execute those files, much slower than SSMS. Any idea?<br /><br />Thanks!二百五https://www.blogger.com/profile/11067198099350492122noreply@blogger.com