my website working but its down coz ms sql

naeem.net · October 10th, 2008, 10:46 AM

Hi friends,

I have website online and its working fine, its full dynamically using MS Access database, I try to change the database to be Ms sql server 2005 and working successfully, my problem is the website some time is down and not work, when I checked it with our server company , they informed us there is some problem in the code issue.
any one can help me how can fix this problem??

Ali Naeem

Imar · October 10th, 2008, 10:56 AM

As Ken used to say: The error is on line 11....

Seriously, what do you expect us to say or suggest? How can we suggest something even remotely useful without knowing about your site, its setup, the code and so on?

You'll need to provide *a lot* more information in order for us to suggest something useful.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

naeem.net · October 10th, 2008, 11:03 AM

Hi Imar,
Thanks for your reply, kindly do u like to send u the webcofig cods and some code of our pages?

Ali Naeem

Imar · October 10th, 2008, 11:07 AM

That's a bit too early, I guess. You need to dig into the problem deeper first. Do you get an error message? If so, what's the exact error? What's the behavior you are seeing in your application? How do you define "the website some time is down"? Are you seeing application restarts in IIS? Based on what assumptions is your host blaming your code?

And so on....

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

naeem.net · October 10th, 2008, 03:27 PM

Look,the website is working proberly and i didnt get any error message, the website down is meant the index page cant display just blank page, so I must restart the webserver in order the website right back work again. the code i using is VB asp.net2.0 and ajax.

here is below the web.config file i using:

<?xml version="1.0"?>
<configuration>
    <configSections>
        <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensions SectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
            <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGro up, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
                <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptReso urceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
                <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebService sSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
                    <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerial izationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>

                    <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthentica tionServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
        </sectionGroup>
            </sectionGroup>
        </sectionGroup>
    </configSections>
   <appSettings>
      <add key="ali" value="naeem" />
   </appSettings>
   <connectionStrings>
      <add name="aafaqConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirector y|mydatabase.mdf;Integrated Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/>
     <remove name="LocalSqlServer"/>
  </connectionStrings>
  <system.web>
    <authentication mode="Forms"/>
    <customErrors mode="Off"/>
        <pages>
      <controls>
        <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
                <add tagPrefix="ajax" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/>
            </controls>
        </pages>
        
        <compilation debug="true">
      <assemblies>
                <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies>
        </compilation>
        <httpHandlers>
            <remove verb="*" path="*.asmx"/>
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFact ory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFact ory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
        </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </httpModules>
        <globalization requestEncoding="utf-8" responseEncoding="utf-8" fileEncoding="utf-8"/>

  </system.web>
<system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules>
            <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </modules>
        <handlers>
            <remove name="WebServiceHandlerFactory-Integrated"/>
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFact ory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFact ory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
        </handlers>
  </system.webServer>
</configuration>

Ali Naeem

Imar · October 10th, 2008, 03:45 PM

And how would a web.config file help in diagnosing the problems?

There could be many reasons, from DNS issues with your host, application pool recycles due to memory problems, hard ware / network failures and so on. Or maybe you have Plesk installed on the server causing unexpected behavior? (Seen that once).

This is not something we can fix for you. This needs to be fixed right where the problem is: at the server, with a lot of diagnostics tools, lots of coffee and support from your host.

Tell them to look into this. Tell them the site runs fine on your own machine (make sure you do some load and stress testing before you say so) and have them look at it. If they can't / don't want to help, consider changing hosts.

Sorry.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.