Home » Categories » Multiple Categories

I receive this error message: "Unknown file type (binary data)" when trying to deploy my SQL CE database. What did I do wrong?

If you receive this error message, please try adding the following line to your web.config file:

<identity impersonate="true" userName="XXXXXXXXX" password="XXXXXX" />

This line should be added inside the tag <system.web> </system.web>. Username and password can be your login credentials for the system.

Therefore, the following is the whole web.config-content with which everything works:

<?xml version="1.0" encoding="UTF-8"?>
     <configuration>
          <system.data>
                 <DbProviderFactories>
                          <remove invariant="System.Data.SqlServerCe.4.0" />
                          <add invariant="System.Data.SqlServerCe.4.0" name="Microsoft® SQL Server® Compact 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" />
                 </DbProviderFactories>
          </system.data>
       <system.web>
           <identity impersonate="true" userName="???" password="???" />
       </system.web>
</configuration>

Please note that our Control Panel does not really accept the .cshtml-files (webpages) and the .sdf-file (database) and you will always see the error message: "Unknown file type (binary data)". However, please just ignore the error message and by following the above guideline, everything will work as expected.



 

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Do you support MS SQL Profiler?
Viewed 2919 times since Wed, May 23, 2012
What is my MS SQL Connection String on my SQL Management Studio tool?
Viewed 46443 times since Tue, May 1, 2012
What is the connection string for my MySQL database?
Viewed 3653 times since Mon, May 7, 2012
Do you support SQL 2014?
Viewed 3045 times since Tue, Feb 3, 2015
How can I deploy my VS LightSwitch project on your server?
Viewed 3629 times since Tue, May 22, 2012
Do you support Remote MSSQL connection?
Viewed 3489 times since Mon, Apr 30, 2012
How do I query MySQL database in ASP.NET?
Viewed 12133 times since Tue, May 1, 2012
Can I have one database user associated to more than 1 MS SQL database?
Viewed 2933 times since Tue, May 1, 2012