edit-task
Home
Up
Delete
Task Name:
Task Description:
PRB ERROR access denied - sqlce (cc VS ) ] SUPPORT#
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center; padding-left: 30px;">PRB - access denied</h1> <h2>[previously]</h2> <ol> <li>*] getting this with test</li> </ol> <h2>[currently]</h2> <ol> <li>] web.config</li> <ol> <li>] modifed to add entry for new ver of sqlce</li> <li>*] removed other entries</li> </ol> <li>] bin/sqlce.dll REPLACED with</li> <ol> <li>x] newer version FROM local ProgramFile/Sql-Server-CE/</li> </ol> <li>] bin/X86/*.*</li> <ol> <li>x] replaced approx 6 dll files, with NEW versions from new starterSite project</li> </ol> <li>] bin/amd</li> <ol> <li>x] replaced approx 6 dll files</li> <li>x] config folder?</li> </ol></ol> <h2>[next]</h2> <ol> <li>] WAS fight with config file</li> <li>] turns out 1 - HAD replaced .dll on server BUT b/c local file was old version, after updating other files it overwrote the</li> <li>] turns out 2 - the .dll's in the /X86 and /AMD folders are newer versions as well</li> </ol> <p> </p> <hr /> <p>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.<br /><br /> And include this to your web.config:</p> <p>ADDED -</p> <p><system.data><br /> <DbProviderFactories><br /> <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" /><br /> </DbProviderFactories><br /> </system.data></p> <hr /> <p><strong>x] REMOVED 4 LINES FROM MY WEB.CONFIG</strong></p> <p>1] <remove invariant="System.Data.SqlServerCe.4.0" /></p> <p>] <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" /></p> <p>] <clear /></p> <p>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" /> </p> <p><strong>x] ADDED both lines back in</strong></p> <p>- ERROR =</p> <p><strong>x] REMOVED this line</strong></p> <p><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" /></p> <p><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" /></p> <p> <strong>-- LOCAL TEST = PASS</strong></p> <p>1] <remove invariant="System.Data.SqlServerCe.4.0" /></p> <p>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" /></p> <p><strong> -- REMOTE FAIL - ERROR</strong></p> <p><em>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</em></p> <p><em>.</em></p> <p> </p> <p> </p> <p> </p> <p> </p>