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 set up additional logins for my MS SQL database?
Viewed 3175 times since Mon, Apr 30, 2012
How can I activate my Crystal Report?
Viewed 3847 times since Tue, May 1, 2012
Will my Crystal Report IX (Crystal Report 9) work on your server?
Viewed 2891 times since Tue, May 1, 2012
My website session times out earlier than expected. Why?
Viewed 5149 times since Tue, May 1, 2012
Do you support SQL 2012?
Viewed 3544 times since Fri, May 4, 2012
Do you support MS SQL WebAdmin access?
Viewed 5755 times since Tue, May 1, 2012
How can I change my SQL Server collation name?
Viewed 3688 times since Mon, May 21, 2012