It says it supports CE 4.0, but it's not

Mar 7, 2011 at 9:12 AM

Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = Entities.sdf ]

Coordinator
Mar 7, 2011 at 7:54 PM

Have you tried with the CE4.0 installer "CEQuery v6 for SQL Server CE 4.0" ? For older version of CE database, you have to upgrade the db to 4.0. The upgrade feature is availabe in the 4.0 Installer.

But the error message you have provided only comes if you try to open a SQL CE 4.0 database in the CEQuery version for SQL CE 3.5. Please try uninstall the application and install "CEQuery v6 for SQL Server CE 4.0" from the Download section.

Thanks

Mar 8, 2011 at 6:46 AM

You're right, I've somehow managed to install wrong version.

Anyway, i couldn't get to work it:

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************System.BadImageFormatException:  is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)   at System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName)   at System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath)   at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath)   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall)   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()   at System.Data.SqlServerCe.SqlCeConnection..ctor()   at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)   at CEQuery.OpenDB.btnOK_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms.ButtonBase.WndProc(Message& m)   at System.Windows.Forms.Button.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************mscorlib    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll----------------------------------------CEQuery    Assembly Version: 6.0.0.0    Win32 Version: 6.0.0.0    CodeBase: file:///C:/Program%20Files%20(x86)/Mayukh's%20Lab/CEQuery/CEQuery.exe----------------------------------------System.Windows.Forms    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Drawing    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Data.SqlServerCe    Assembly Version: 4.0.0.1    Win32 Version: 4.0.8402.1    CodeBase: file:///C:/Program%20Files%20(x86)/Mayukh's%20Lab/CEQuery/System.Data.SqlServerCe.DLL----------------------------------------System.Data    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Transactions    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------
************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.
For example:
<configuration>    <system.windows.forms jitDebugging="true" /></configuration>
When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.

Coordinator
Mar 8, 2011 at 3:14 PM
Edited Mar 8, 2011 at 3:15 PM

Hi

From the error I can get that you are using a 64bit system. I have developed it in 32bit system. Have not tested in 64bit machine.

Anyways, I have built another installer for 64bit system. Can you please install "CEQuery v6 for SQL Server CE 4.0 [x64]" from the download section and let me know if the problem still exists?

Thanks

Mar 9, 2011 at 6:02 AM

sadly it gives the same exception. anyway, if i'll find a free minute, i'll take a look at the source and try to build by my self and will give you know if any changes required.

 

 

 

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************System.BadImageFormatException:  is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)   at System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName)   at System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath)   at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath)   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall)   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()   at System.Data.SqlServerCe.SqlCeConnection..ctor()   at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)   at CEQuery.OpenDB.btnOK_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms.ButtonBase.WndProc(Message& m)   at System.Windows.Forms.Button.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************mscorlib    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll----------------------------------------CEQuery    Assembly Version: 6.0.0.0    Win32 Version: 6.0.0.0    CodeBase: file:///C:/Program%20Files%20(x86)/Mayukh's%20Lab/CEQuery/CEQuery.exe----------------------------------------System.Windows.Forms    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Drawing    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Data.SqlServerCe    Assembly Version: 4.0.0.1    Win32 Version: 4.0.8402.1    CodeBase: file:///C:/Program%20Files%20(x86)/Mayukh's%20Lab/CEQuery/System.Data.SqlServerCe.DLL----------------------------------------System.Data    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Transactions    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------
************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.
For example:
<configuration>    <system.windows.forms jitDebugging="true" /></configuration>
When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.

Coordinator
Mar 9, 2011 at 6:51 AM

Sorry to hear about that. I believe I can figire out the problem. The installer has built on SQL SERVER CE 4.0 x86 assembly.  I need to create a separate installer for x64 assembly also.

Thanks

Coordinator
Mar 11, 2011 at 7:49 AM

Hi

I have created a separate installer isolated from the SQL Server CE 4.0 installer. Please download the Installer "CEQuery v6 for SQL Server CE 4.0 [Any CPU]" and install it in your machine. Also please install the x64 version of SQL Server CE 4.0 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=033cfb76-5382-44fb-bc7e-b3c8174832e2. Then please try to run the application and let me know if you can use the app.

Looking to hear from you.

Thanks