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
Can I have one database user associated to more than 1 MS SQL database?
Viewed 3434 times since Tue, May 1, 2012
Can i login to my MySQL database via my own mySQL tool?
Viewed 3164 times since Mon, May 7, 2012
About Azure Key Vault
Viewed 1842 times since Mon, Nov 2, 2020
How can I change my SQL Server collation name?
Viewed 3622 times since Mon, May 21, 2012
Can you grant SELECT PRIVILEGE to the system table mysql.proc
Viewed 6308 times since Mon, Jun 18, 2012
How can I deploy my website with WebDeploy tool?
Viewed 6485 times since Mon, Apr 30, 2012