Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
11/7/2011 3:47:34 PM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

I think this is not a good thing... If I have all in the app_data , your code has to work...

 but now i want to check the path.... now i check... ;-)

11/7/2011 4:35:58 PM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

So... uuuu I have made this steps :

 I have made a my asp net page ...

 A)  I have tested the "~/app_data" was correct ----> It's OK 

 B) I have then made a connection to a my db.sdf made with sql ce 4.1 --> was wrong (error)

     So i upload the   System.Data.SqlServerCe.Entity.dll  and  System.Data.SqlServerCe.dll 
     with x64 --- > It was wrong (error)

    So i upload the x86 and it was OK !!!!!!!!!!!!!!!!!!!!!    <---- OK

   I was able to connect and query my db.sdf sql ce 4 database ......... using this connection string in web.config

     connectionString="Data Source=|DataDirectory|\profilerDb.sdf"  or  connectionString="~/App_Data/ProfilerDb.sdf"

     

     so ... i think that .... may be i have to upload System.Data.SqlServerCe.dll and x86 dlls   in the bin folder ?????

    

 

 

 

11/7/2011 5:23:26 PM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

  I think some code is wrong....

  If you can get me some tests to do .... 

  I repeat :  my tests with a personal asp .net page was all right !!!!!! 

  So i think the MOJO code has some problems... ???

  If you include some preliminar test in the setup it would be better .... ;-)  

  

  Could you give me the code that perform the sql ce connection and creation ???? ;-)

  so i try to test that for MOJO project... ;-)

  Good night  from Italy !!

 

11/7/2011 5:45:23 PM
Gravatar
Total Posts 1203
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

mojoPortal is completely open source. I'd recommend downloading the code with TortoiseHG, and take a look at the SqlCE data layer functions to see where it differs from your implementation. You can also run mojoPortal in debug mode, in case that will help you pinpoint the problem.

11/8/2011 2:42:53 AM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

The content that belongs here is too complex to display securely.
11/8/2011 3:19:47 AM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

 You have to update the code about Mojo  2.3.7.0 .. ;-)

11/8/2011 8:00:59 AM
Gravatar
Total Posts 18428

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

Hi,

I found that I am able to reproduce this error under medium trust hosting, but previously it worked fine so I'm suspecting that some Windows Update may have changed things.

I did find that we have version 4.0.8402.1 of SQL Ce dlls, so I updated to the newer version 4.0.8482.1 on my local machine, but the problem still persists under Medium Trust. With Full Trust it works correctly.

I have emailed my contacts at Microsoft to find out if they can help. The full error details are:

An unhandled exception occurred and the process was terminated.

Application ID: /LM/W3SVC/1/ROOT

Process ID: 5488

Exception: System.TypeInitializationException

Message: The type initializer for 'System.Data.SqlServerCe.SqlCeConnection' threw an exception.

StackTrace:    at System.Data.SqlServerCe.SqlCeConnection.Finalize()

InnerException: System.TypeInitializationException

Message: The type initializer for 'System.Data.SqlServerCe.KillBitHelper' threw an exception.

StackTrace:    at System.Data.SqlServerCe.KillBitHelper.ThrowIfKillBitIsSet()
   at System.Data.SqlServerCe.SqlCeParameter..cctor()

InnerException: System.InvalidOperationException

Message: Cannot perform CAS Asserts in Security Transparent methods

StackTrace:    at System.Security.CodeAccessSecurityEngine.CheckNReturnSO(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 create)
   at System.Security.CodeAccessSecurityEngine.Assert(CodeAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Assert()
   at System.Data.SqlServerCe.KillBitHelper.GetKillBit()
   at System.Data.SqlServerCe.KillBitHelper..cctor()

As far as your comments about trying to handle this error, we do check if we can connect to the database, if we can alter the schema etc, but this error happens before that, just in trying to create a connection, the error is not happening in mojoPortal code it happens in the SQL CE dlls and it only happens under partial trust hosting.

I will post again if I find a solution. For now I would see if you can get full trust hosting if you want to try mojoPortal with SQL CE.

Best,

Joe

11/8/2011 8:22:59 AM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

  No no Joe...

  that's not the problem....  SO WHY i'm able to run all OK with my asp .net page ???

 and if I run with sql server 2008 is also OK ?? 

 ​I think that the error is in another place... Can you post me the code about sql ce 4 ??

 thanks ... so I try to test the code... ;-)

11/8/2011 8:41:23 AM
Gravatar
Total Posts 18428

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

Hi,

Ok, I heard back from my contact at Microsoft. It seems that when I updated to the newer version of the SQL CE dlls I used the "private" when I should have used the "desktop" version.

I have updated the mojoPortal 2.3.7.0 package for SQL CE. If you download it again and replace the files in the /bin folder it should work now.

Hope that helps,

Joe

11/8/2011 8:45:47 AM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

  Ahahah oh yeah !!!! 

  That was the mistake ??? ahahaha ;-) 

  For the damnation of the dark !!!!!!!!!

  Now I try ... than I offer you 4 biers so you can think better & better ahahah !!! ;-)

 

11/8/2011 9:39:53 AM
Gravatar
Total Posts 26

Re: Mojo 2.3.7.0 SqlCe Installation FAILURE on Aruba Hosting

 Uhuh this is a very hard question boys ..... 

     NOT WORKING YET ---- other mistake ... Joe !!! ;-)     rechecks !!! ;-)

Et voilà the secret :=> 

 Welcome to mojoPortal Setup

Verifica del sistema...
An Error Occurred:Could not load file or assembly 'System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

 

Source:mojoPortal.Data


Stack Trace at mojoPortal.Data.DBPortal.EnsureDatabase() at mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

You must sign in to post in the forums. This thread is closed to new posts.