KB Home \| Advanced Search \| News \| Glossary \| Login
ASP.NET Hosting Knowledge Base

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

Article Number: 113 | Rating: 5/5 from 1 votes | Last Updated: Thu, May 3, 2012 at 11:40 PM

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

I cannot login to my MS SQL database remotely. What did I do wrong?

Viewed 6471 times since Mon, May 7, 2012

Do you support SQL Reporting Service (SSRS)?

Viewed 4065 times since Tue, May 1, 2012

How can I deploy my website with WebDeploy tool?

Viewed 6340 times since Mon, Apr 30, 2012

How to solve ReportViewer error message: "An error has occurred during report processing. Input string was not in a correct format"

Viewed 8170 times since Tue, Jun 18, 2013

How can I deploy my ASP.NET project with WebDeploy facility via Visual Studio 2010 tool?

Viewed 5728 times since Wed, Jun 6, 2012

Do I need a static IP?

Viewed 4875 times since Mon, May 7, 2012

My application pool stops working. What is wrong with my site?

Viewed 13194 times since Sun, Feb 15, 2015

I cannot find any article on this Knowledge Base that can solve my issues. What should I do?

Viewed 4139 times since Mon, Apr 30, 2012

Can I set up additional logins for my MS SQL database?

Viewed 3010 times since Mon, Apr 30, 2012

Can I have more than one MS SQL database on my hosting account?

Viewed 3726 times since Tue, May 1, 2012