IIS & databse

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Turi (ivaturi_at_gmail.com)
Date: 10/07/04 

Date: 7 Oct 2004 12:03:02 -0700

Sorry for cross-posting but I never got any reply on the other
newsgroup. Here is my story...

We have IIS v5.0 running on Wn2000 server. We have a SQL server 2000
on the same machine. When we write asp scripts without database
connection, it works fine. But when in any of the script if we try to
make a database connection, the IIS server does not serve any more
pages. Here is the interesting part I don
t get any errors at all neither HTTP errors nor asp errors. The event
log is also clean. Its as if the server has just went in to sleep
mode.

We tried DSN, DSN-less connection and same results. So we thought
probably our SQL server was messsed up. So I went ahead and set up IIS
server on my home computer and created an asp page in which it queries
our main server at the office and it works! No problem at all.

So is there a way the asp engine can somehow get corrupt and choke on
SQL connections? But without any errors of any kind it is indeed hard
to figure out what the heck is wrong with the server. Any suggestions?

Relevant Pages

  • Re: Problem with ASP on Webserver
    ... I just enabled more ASP debug information and the dump looks like this: ... calling service 0x00044110 with connection socket ... (Accept-Language:) ... Server: Microsoft-WinCE/5.0 ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Problem with ASP on Webserver
    ... I just enabled more ASP debug information and the dump looks like this: ... calling service 0x00044110 with connection socket ... (Accept-Language:) ... I have a problem with the web server on windows CE 5.0 when running an ASP ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Sql Ole problem with Sql 6.5
    ... Check the client side libraries on the ASP.NET machine versus the ASP ... not be able to use .NET with your server unless you add other libraries. ... > connection scripts on my ASP pages and it works fine. ... > Dim ConnectString, SelectStatement As String ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Force error message when database is missing
    ... connection, after attempting to update... ... I have a FrontPage ASP file writing form data to an Access database on ... a different server. ...
    (microsoft.public.frontpage.programming)
  • Re: database connections problem
    ... You could try to find out if its the DB Connection or if its the ASP ... ISAPI filters by writting some other ADO ... Then try running it from the server, ...
    (microsoft.public.inetserver.iis.activeserverpages)