fails in W7 64bit environment

Jan 23, 2012 at 6:47 AM

thanks for your time

I think I read every possible piece of documentation around KB974247 and applied the SSCEruntime ... as described but I'm stll getting following error as seen below!

environment:
CEQuery 6.0.0.0 / 4.0.0.1
W7ult 64bit
SQL serverCompact 3.5 SP2 ENU 3.5.8080.0
SQL serverCompact 3.5 SP2 ENU x64 ENU 3.5.8080.0
SQL serverCompact 4.0 WEB Tools ENU 4.0.8482.1
SQL serverCompact 4.0 SP2 ENU x64 ENU 4.0.8482.1

In another thread you mentioned to apply "CEQuery v6 for SQL Server CE 4.0 [Any CPU]" but I can't find / apply it!

? What I'm possibly missing here ?

any hint are highly apppreciated, ed

************** Exception Text **************
System.Data.SqlServerCe.SqlCeException: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.
   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.PerformClick()
   at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)
   at System.Windows.Forms.Control.PreProcessMessage(Message& msg)
   at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)
   at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5448 (Win7SP1GDR.050727-5400)
    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.5446 (Win7SP1GDR.050727-5400)
    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.5447 (Win7SP1GDR.050727-5400)
    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.5420 (Win7SP1.050727-5400)
    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.8482.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.5420 (Win7SP1.050727-5400)
    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
----------------------------------------

Feb 28, 2012 at 5:25 PM

Same problem. Any help ?

Coordinator
Mar 1, 2012 at 4:32 AM

OK.. I have tested the CEQuesry for SQL CE 4 and got same error in 64bit machine... Here is the solution.

1) Install the SQL Compact frameword 4 x64 (SSCERuntime_x64-ENU.exe) from the following location: http://www.microsoft.com/download/en/details.aspx?id=17876 

2) Now go to "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0" [Assuming this is the location for SQL CE4] and copy the following DLLs and paste the same in the CEQuery Installation Directory ["C:\Program Files (x86)\Mayukh's Lab\CEQuery", assuming this is the CEQuery install location].

  • sqlceca40.dll
  • sqlcecompact40.dll
  • sqlceer40EN.dll
  • sqlceme40.dll
  • sqlceoledb40.dll
  • sqlceqp40.dll
  • sqlcese40.dll

 Let me know if this solve the issue or not.

~Mayukh

 

Mar 1, 2012 at 6:32 AM
Thanks mayukh for taking the time ...

I will test asap BUT right now I have the Machone in question with a motherboard issue and cannot test! Well, I'll follow the thread ... and I'm confident that the issue will ger resolver
ed


On Thu, Mar 1, 2012 at 6:32 AM, mayukh_cts <notifications@codeplex.com> wrote:

From: mayukh_cts

OK.. I have tested the CEQuesry for SQL CE 4 and got same error in 64bit machine... Here is the solution.

1) Install the SQL Compact frameword 4 x64 (SSCERuntime_x64-ENU.exe) from the following location: http://www.microsoft.com/download/en/details.aspx?id=17876

2) Now go to "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0" [Assuming this is the location for SQL CE4] and copy the following DLLs and paste the same in the CEQuery Installation Directory ["C:\Program Files (x86)\Mayukh's Lab\CEQuery", assuming this is the CEQuery install location].

  • sqlceca40.dll
  • sqlcecompact40.dll
  • sqlceer40EN.dll
  • sqlceme40.dll
  • sqlceoledb40.dll
  • sqlceqp40.dll
  • sqlcese40.dll

Let me know if this solve the issue or not.

~Mayukh

Read the full discussion online.

To add a post to this discussion, reply to this email (CEQuery@discussions.codeplex.com)

To start a new discussion for this project, email CEQuery@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Mar 5, 2012 at 5:59 AM

Mayukh

your advise /procedure solved my problem ... Thank you