Last post Dec 20, 2010 01:02 PM by farm boy
Dec 18, 2010 03:40 PM|farm boy|LINK
Does anyone know of a hosting service that supports Dynamic Data?
DD Hosting Service
Dec 18, 2010 05:07 PM|XIII|LINK
any hosting that has ASP.NET 3.5sp1 or ASP.NET 4.0 hosting will do.
Dec 18, 2010 06:18 PM|farm boy|LINK
Thanks for that.
My real problem is that I have spent weeks developing a prototype dynamic data website that works on my local machine (Win 7 pro/Sql Server 2008) but after uploading it to my Asp.Net 4.0 enabled hosting service the home page loads but I get server errors
when I try to access any pages from the main menu.
I find it quite strange that the home page loads and I can see all the page links but as soon as I click on any page/table link, I get an error such as
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xxxx'.
Any ideas on what might be causing this?
Dec 19, 2010 03:45 AM|XIII|LINK
System.Data.SqlClient.SqlException: Login failed for user
It means that your application can't connect with your database. Make sure that your application account has enough privileges and that your connectionstring in the web.config is properly adjusted. Ask your hosting company for details on how to set this
up/adjust it as it's specific for them. Most hosting companies have also FAQ pages as this is a more common problem and they most likely put it already in a FAQ.
Dec 19, 2010 04:25 AM|farm boy|LINK
It's fixed now. The problem was in the connection string.
It was pointing to the wrong database.
And another problem solved.... Yadaaaa
Thanks for your response.
Dec 20, 2010 11:16 AM|PeterSkellern|LINK
Thank you. This is something not trivial at all. I have found many Linux, MySql, PHP, etc. hosting services but just a few Windows SQL-Server ones. You will probably think that I should research more and I am doing it but there is something many of us should
be aware: windows host offer mostly shared hosting with a limit up to 200 Mb database space for all of your databases and Framework 3.5 not 4. On the other hand, there are many windows hosting servers but in "dedicated" mode whose costs are above $200/month
which is really expensive
If you want to go online for business you will find many shopping carts supposedly fully integrated but it is not really simple trying to implement those into your ASP.Net application. Many of them use .cgi routines and HTML pages., they also manage their
own .css, file system, database, etc. So they seem more PHP oriented than ASP.Net
I will kindly ask anyone of you in sharing real life experiences about this. I am currently using
www.fieldco.com hosting services but I had to go back to Framework 3.5 with them
About costs: online SSL certificates are really expensive. Verisign is about $1,550 /year. Verizon is $350, Thawte is $600/year and GoDaddy is cheapper but many hosting services deny using it.
One more thing: I feel a little disspointed with my ASP.Net Dynamic Data application deployed in a real host server. I must also say that sometimes it hangs up even in my development computer. I have not found information about this during my own research.
Any help will be very welcomed
Dec 20, 2010 01:02 PM|farm boy|LINK
Well I can't comment on your existing provider - I have never used them.
However I can strongly recommend the services that I use.
Between 1999 and 2007, I used several hosting services.
I won't name them here, but one general characteristic that I observed was that most of the support staff seemed to know less than I did. ( I started getting serious with computers in 1971).
In 2007, after getting frustrated with my existing asp.net 2.0 hosting provider, I discovered
AquestHosting . Now, after more than three years of running
my website (asp.net 2.0 + SQL Server 2005) with them, I still have nothing but praise for their service.
Their support staff are technical wizards rather than the usual "help desk staff" and you always get a super fast response to your problems.
In three years I think that their service has been down for less than about 15 hours total. (I have not counted)
Now I'm working with a prototype DD application using ASP.Net 4.0 and SQL Server 2008 SP2 and the superb suppport continues. They have a 1GB link to the internet so speed has never been a problem.
And all this for a very reasonable price!
SSL Certificates etc
I have tried Verisign and Comodo but about two years ago I consolidated all my domain and SSL services with GoDaddy. The main reasons being price, speed and service simplicity. From what I have seen, Godaddy SSL's are a fraction of the price of the others
and I don't think that there is much (if any) difference in the functionality.
For example, last night, I decided to set up SSL on one of my new websites at AquestHosting and it took less than an hour from deciding to do it to having it
installed. (The procedure is 1. Get your hosting service to generate a CSR and email it to you, 2. Buy the SSL certificate at the SSL certificate provider, 3. Download the SSL certificate and send it to your hosting service. 4. Your hosting service installs
Hope that this answers your questions.