Shared (hosted) MS SQL Server 2000

I have hit a strange problem. I have one application deployed on 2 different websites. They both access the same database. The connection string in the web.config is same. The problem is that on one website I have started getting 'Connection Timeout' message. This website has stopped completely and I keep getting timeout error. I have ConnectionTimeout = 1000 in my code. However, on the second website, the same application is able to connect to DB without any problem. So I am not sure why one website is able to connect to a DB and another cannot. Any thoughts on this please. Thanks

To me , it does not seem like a authentication or session expiration problem. The users are still logged in when they click on the link twice. It seems more like a caching problem on the client side

Hi I created my site in asp.net 1.1 It has been running for quite a while now. However, recently, I have started having problems with it. First, I was have a 'Unable to validate data' problem. I resolved this issue by adding the following to my web.config file: enableSessionState="true" enableViewState="true" enableViewStateMac="false" /> However, I am having another strange problem. I have a secure page (Web_page.aspx) and requires the user to be logged in to the site. I perform this check with the following code in web_page.aspx: if(!Context.User.Identity.IsAuthenticated) { Response.Redirect("login_page.aspx"); } else { continue with the page} The problem is that: If a person is logged in and he clicks on the web_page.aspx link, the system redirects them to login.aspx page (the system should take them to the web_page.aspx page because the user is already logged in). At this if the user clicks on web_page.aspx link AGAIN, then it works correctly, i.e. I am taken to web_page.aspx. As you can see, I have to click TWICE on this link to make it work correctly. This is happening with ALL the pages that require login. Very strange indeed. Any idea what is happening here? My system was working correctly in the past. This problem has just emerged.

How would I create a new Data Connection to a database. I am assuming if the Database Explorer is not working, I cannot create any connection. Would I specify anything in the web.config? Thanks

I am having problems with Visual Web Developer express edition. The 'Database explorer' menu under View menu, does not work. When I click on it, nothing happens. How can I remedy this problem? I have installed SQL Server 2005 express edition as well. Thanks

Currently, I am using the DataList to display the data. My DataList code looks something like this: Name: <% DataBinder.....%> Company: <% DataBinder.....%> My question is: How can I have an easy way of sorting this data. I would like the users to be able to sort the data by Name or by Company. I understand I can add AllowSorting to DataList or DataGrid, but then I would have to display the column names and display the data in 2 columns, which I dont want to do. So is there any other way to allow the users to sort this data, without having to write much code? I am using ASP.NET 2. Thanks

I am trying to understand how YouTube and Google convert the videos into Flash videos. If I were to create a similiar website (using .Net), how would I convert the uploaded videos into Flash video? Also, How can I make sure that the system is resilient and robust in uploading large files. What should I remember when designing such applications. I will be using FileUpload web control in my application. Thanks

I am trying to understand how to send HTML emails to the users. The content of the emails can vary according to the users, e.g.: Dear [CustomerName] Thanks for your orders. Your order number is [OrderNumber]..... How can I create / manage email content such as above. I am also interested to know how does Amazon create their emails. Because the whole content of their emails is tailored for each individual customer. Thanks

I am following this article to import data from CSV file into my database table: http://www.codeproject.com/aspnet/ImportExportCSV.asp[^] The problem I am facing is that one of my table contains a money data-type column. Therefore, my application gives me Conversion error. When I try to import data from csv file into this table, I get: Disallowed implicit conversion from data type varchar to data type money, table 'MyTable', column 'Total'. Use the CONVERT function to run this query. The above article that I am following, puts all the data values from the csv file into quotes, such as: Insert into MyTable...... Values ('value 1','23.34'...). Thus SQL cannot convert 23.34 into money. Any way to solve this problem? Thanks

Thanks for the above link According to the article, I need to run InstallSqlState.sql to use the SQLServer state. This script creates a new database in my SQL server. This is OK if I owned the SQL Server. However, i have a shared SQL server account, hosted by third party and therefore, I cannot create a DB myself. This means that people who have hosted databases, they cannot use SQLServer state for their asp.net applications.

For my applications, I have always used "InProc" session state. But I want to understand how to build applications using StateServer and SQLServer. Can anyone point me to a relevant resource that shows how to build applications using StateServer and SQLServer. Thanks

the problem was that the log file was full: run this command to delete the log: dump transaction DATABASE_NAME with no_log

Hi What is the easiest option for Exporting ALL of my SQL Server tables into a CSV file (either separate CSV files for each table or one big file with all the table columns and data) ??? I just want to Backup my SQL Server database like we backup MySQL database using phpMyAdmin. Unfortunately, my SQL hosting company does not allow backups for free. Thanks for help

I have some pages that require authentication. I access these pages using HTTPS... I have set my session timeout to 60 minutes: However, the system is very unreliable. Sometimes, I get logged out of secure pages after 5, 10 or 15 minutes on inactivity. Would be grateful if someone could inform why the system logs me out after inactivity which is less than 60 minutes. P.S In my code-behind page, I use: private void Page_Load(object sender, System.EventArgs e) { //if not authenticated if (!Context.User.Identity.IsAuthenticated) { Response.Redirect("...."); } } So actually I never use the login page as specified in the web.config file

Hi I am running my database on a shared 3rd party server. Recently, when I try to connect to the DB from my website, Asp.net gives me the following error: "SQL Server does not exist or access denied." [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 MyCompany.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName) ..... .... For instance, this morning the website was working fine, but now suddenly, I am getting the above error. The same problem happened on other days, as well. Do you think, there is a problem with my code, or is this SQL Server problem?

I just realised that I can type http://www.bbc.co.uk/robots.txt and see all the directories that BBC does not want me to access. robots.txt seems like a very dangerous file as it gives easy information to the potential mis-users. Is there any way around it? Thanks

Hi I have a problem with the robots.txt and google. I have this robots.txt file: User-agent: * Disallow: page1.html Disallow: dir_1/sub_dir_1/ Disallow: /data/ When I enter 'site:www.MySite.com' into Google search box, Goolge gets the content from the 'data' directory as well. Google should not have indexed the content of data directory. So why is google getting the results from 'data' directory, whereas I have disallowed it. How can I restrict everyone from accessing the data directory? Thanks

Hi In my Web Form, I have this code: Then in the code-behind file, I set the title of the page dynamically. My problem is that sometimes, my web form deletes runat="server" property from the tag automatically. Because it deletes the <b>runat </b>property, my page stops working. I manually have to add <b>runat="server"</b> into the <title> again. So please tell how I can solve this problem. Thanks </x-turndown>

Hi Sometimes, I get the following problem: I create WebForms in VS.net. I drag & drop a button on the WebForm. Then I double click it to write the event code in the code-behind file. Then I test the button event on localhost and it works. Then I deploy the project on a Live shared server. I click on the same button, and nothing happens. If I include the onclick= "Button1_Click" to the html code , then the button event works on both: localserver & live server. So please tell me why I get this problem for some Button controls and how I get solve this problem ? (As I said I dont get this problem all the time)