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.
Article ID: 113
Created On: Thu, May 3, 2012 at 11:39 PM
Last Updated On: Thu, May 3, 2012 at 11:40 PM
Authored by: ASPHostServer Administrator [asphostserver@gmail.com]
Online URL: http://faq.asphosthelpdesk.com/article.php?id=113