You must Sign In to post a response.
  • Category: Complaints

    How to connect to *.sdf database file

    I copied my file sdf in the directory App_Data, but when trying to access the database from the program, I get an error "Access to the database file is not allowed". How it is possible to fix this error?
  • #7037
    This is not an error just hosting works with full SQL Server databases (files *.dbf), you need your database to SQL Server Compact Edition (file *.sdf) to export into a full-fledged SQL Server database using the import export wizard SQL Server 2008 is very quickly then attach it to SQL Server 2008 for hosting (as described in the instructions aspspider). And Microsoft does not recommend to use the desktop version of SQL Server CE to work with IIS. Use this version of SQL Serevr to work with desktop or mobile applications.


  • Sign In to post your comments