task

PRB - access denied

[previously]

  1. *] getting this with test

[currently]

  1. ]  web.config
    1. ] modifed to add entry for new ver of sqlce
    2. *] removed other entries
  2. ] bin/sqlce.dll REPLACED with
    1. x] newer version FROM local ProgramFile/Sql-Server-CE/
  3. ] bin/X86/*.*
    1. x] replaced approx 6 dll files, with NEW versions from new starterSite project
  4. ] bin/amd
    1. x] replaced approx 6 dll files
    2. x] config folder?

[next]

  1. ] WAS fight with config file
  2. ] turns out 1 - HAD replaced .dll on server BUT b/c local file was old version, after updating other files it overwrote the
  3. ] turns out 2 - the .dll's in the /X86 and /AMD folders are newer versions as well

 

You need to copy the x86 and amd64 folders in the C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private folder to your website bin directory. But instead of the System.Data.SqlServerCe.dll in that folder, you need to use the System.Data.SqlServerCe.dll in the C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop folder.

And include this to your web.config:

ADDED -

<system.data>
<DbProviderFactories>
<add name="SQL Server Compact Edition 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition 4.0" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</DbProviderFactories>
</system.data>

x] REMOVED 4 LINES FROM MY WEB.CONFIG

1] <remove invariant="System.Data.SqlServerCe.4.0" />

] <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral,PublicKeyToken=89845dcd8080cc91" />

] <clear />

2] <add name="Microsoft® SQL Server® Compact 4.0"  invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />      

x] ADDED both lines back in

- ERROR =

x] REMOVED this line

<add name="Microsoft® SQL Server® Compact 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

<add name="SQL Server Compact Edition 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition 4.0" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

 -- LOCAL TEST = PASS

1] <remove invariant="System.Data.SqlServerCe.4.0" />

2] <add name="SQL Server Compact Edition 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition 4.0" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

 -- REMOTE FAIL - ERROR

Possible file version mismatch detected between ADO.NET Provider and native binaries of SQL Server Compact which could result in an incorrect functionality. This could be due to the presence of multiple instances of SQL Server Compact of different versions or due to wrong binaries with same name as SQL Server Compact binaries. Please install SQL Server Compact binaries of matching version

.

 

 

 

 

Details Photos Edit more

Details

ID: 3526

NAME: upgrade-tool-WM3-006

DESCRIPTION: PRB ERROR access denied - sqlce (cc VS ) ] SUPPORT#

START DATE TIME: 2014-02-26 17:50:36

EST DURATION: 01:00:00

END DATE TIME: 2014-02-26 18:50:36

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities