.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SQL Compact 4 deployment to Hosting provider

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server

Well, I've looked and can't *quite* find the right answer, so I'll ask it here.

I have a ASP.Net MVC 2 app, using the cool new SQL Compact 4 & EF CTP. Works great.

I tried to deploy it using VS2010 publish to Softsys hosting (chosen from the "learn more" link in VS2010).

I have the db, all the Sql.Data.SqlServerCe*.dll, and hte System.Data.DataSetExtensions.dll, and followed Erik's 3.5 deployment from his blog post (http://erikej.blogspot.com/2010/07/getting-started-with-sql-server-compact.html).

The error is

Unable to find the requested .Net Framework Data Provider.  It may not be installed. 

Obviously, I can't run the sql install here.

Any ideas?

View Complete Post

More Related Resource Links

SQL server compact deployment help

I have a very simple windows desktop app I am trying to deploy using windows installer. I also have a SQL Server compact database file or (Local Database). When I deploy the app and try installing it on my test computer, I get an error saying the database was not found and then it displays the connection string that was set originally in Visual Studio. The application runs but all the database in not there. I don't understand why there is even a connection string there if the database in embedded in the application. Which is one of the benefits of SQL Server  Compact. What should change the connection string to?? Anyone have experience using SQl Server Compact for Win Forms?

need a simple login page cus my hosting provider system wont allow me to have more than one database

I dont really write html code too well  but I manged to get my web site developed and deployed using the built in features such as drag n drop, master page and user account authentication that make web developing almost a codeless experience. However; my hosting provider system wont allow me to have more than one database, this causes problems becasue when I developed my web app using vb2010 web developer (asp.net v2) I used the built in web config tool to manage users for my site, now after I deployed to my domain it all worked ok with the exeption of the login page, when I tried to log in the system threw a error message saying "database not found." or a page of "gobble-dee-gook" that says the same thing When I contacted support (my hosting provider) they said i have to create a table of users in my database file via 2008 sql server, thats ok I can do that, but my real problem is I dont know how to write appropriate code to reference the table. So heres my problem:  I just want to have some kind of login page with a couple of txtboxes and a click button that maybe using the VB code behind or html checks the input variables "username" "password" against something that is hard coded into vb a string variable or a constant and then branches to Mainmenu.aspx if successfull. I just need it real simple, no fancy stuff just a login s

membership using server given by the hosting provider.


HI all,

i have been able to create locally using aspx, the membership login  and registration pages by following the asp membership tuto.

The thing is once i've been provided the new hostname by the hosting compagny i am not able to reflect the same steps into the hostname server ...

should i have only to copy the mdf db to the hostname directory or..should i have  to change the webconfig file somewhere to point the new hostname and the new db / table ??


please help.





Error occurred in deployment step 'Recycle IIS Application Pool': Provider load failure



I am using Visual Studio 2010 to create page layouts and preview images(http://blog.beckybertram.com/Lists/Posts/Post.aspx?ID=71). I was successful in creating page layouts but the image was not coming properly.

So I decided to change the path of image and deploy the project (Empty SharePoint project). But this time, I am getting an error
Error occurred in deployment step 'Recycle IIS Application Pool': Provider load failure
I am sure there is no relation between changing image path in elements.xml and this error.

I also browsed through and found some related issues, but they are not specific to VS 2010 or SharePoint 2010. And I am apprehensive of implementing them.

1. The logged in user is site collection admin and local admin
2. Windows Management Instrumentation service is running
3. App pool's identity is configured to the local admin & password has not changed.

Thanks in advance

Vighnesh Bendre


Membership provider hosting query



Can I use the membership provider api on a hosted service? I can create mssql databases but have no control over iis. Will I be able to use the membership admin webpage on the hosted service?

Am I correct in stating that the api uses ASPNETDB.MDF in the app_data folder as it's database?


SQL Server Compact Edition Device Deployment


We're building a custom PC installation package to deploy our .NET Compact Framework 3.5 / SQL Server Compact Edition based application.  The installation package uses the System.Configuration.Install and calls Process.Start(ceAppPath, iniPath). We are targeting ARM and x86 devices.  Specifically, which SQL Server Compact Edition cab files do we need to install/deploy for our application to run on the these device platforms?

Building a LINQ Provider

Throughout this article, we will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations.

Bar Code Scanners with the .NET Compact Framework

Summary: Learn how to make your applications use bar code scanners in a generic way-ndependent of the specific bar code scanners that are used on different devices. Using the design patterns Façade and Factory, the implementation not only supports multiple bar code scanners, but it also makes it easy to add support for other bar code scanners. After a brief discussion about bar code scanners and the bar code scanner pattern, a download code sample, written in C#, demonstrates the use of the pattern and technologies.

Serial Communication with the .NET Compact Framework

Learn how to make your applications communicate over a serial port and how to handle common issues when implementing serial solutions. After a general discussion about serial communication and a common serial communication standard, this article demonstrates a practical use of the technologies through sample source code written in C#.

Setting the default start page in godaddy hosting?


 How do you set the start page with godaddy hosting? I can see no way of doing this! You do not seem to have access to the IIS settings that allow you to change it!

Membership Provider Conn String


Hello. I've bee successfully using the Asp.Net Membership Provider in my VB.Net 3.5/SQL 2005 web app for a year now (Site A). However, I've added 2 new sites (B and C) (both with their own DB) and now I see a problem. It looks like users that get created for sites B and C also get created in site A. Roles that I create for B and C only get created in A. I think it is a conn string problem.

When I created A, I adde the conn string to my machine.config (not sure why I did this or if it is even needed)...


         <add name="LocalSqlServer" connectionString="Data Source=VS689\SQLEXPRESS;Initial Catalog=SiteA;USER ID=sa;PASSWORD=123456"/>


                <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=blahblah" connectionStringName="LocalSqlS

Which is the best sql provider?


Which is the best sql provider on .NET Framework : DataSet, LINQ, ADO.NET Entity Framework?

Provider Error




I have a web application and a business class library where all database connections are made. Not periodically but quite often, I get an error in the class library when i execute an oledbcommand. I have no problem defining and opening a connection but as soon as I try to execute a command or fill a table by an oledbadaptor, I get this error:

'SQLOLEDB' failed with no error message available, result code: E_FAIL(0x80004005)

After getting this error, when I reset IIS, everything starts to work perfectly but after a while, the same problem occurs again.

Does anyone have a clue about what might cause this problem?

Thanks in advance



Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch


Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50

The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Debugging ASHX after deployment



I'm finished with a part of my ASHX handler and need to test it against the software that'll be calling it using HTTP POST. The software required an https url so I created an internally hosted site in IIS and published the project there. 

Question now is how do I do any debugging on the script to see what data is coming out of it before the data goes back into the software that's calling it? Do I set something on the project itself to be able to step into the published DLL? 

Custom Control Design-Time SiteMap Provider Error


Greetings - I was referred here by MSDN forums hope this is the right place -  

I have a custom control (:WebControl) that renders web.sitemap in a specific way. While it runs error free and produces the expected result, at Design-Time it complains

Error Creating Control - MyControl  The provider 'AspNetXmlSiteMapProvider' specified for the defaultProvider does not exist in the providers collection.

I have discovered that the error is cause by this line of code:

string div = string.Format("<div class='{0}' id='{1}'>{2}</div>", this.CssClass, this.ID.ToString(), EnumerateNodesRecursive(SiteMap.RootNode, level));

or more specifically, by the reference to SiteMap.RootNode - I am not clear what is missing thoough because I have configured the SiteMapProvider in web.config as this:

        <add name="AspNetXmlSiteMapProvider" 
             type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend