0113 timeout

From: middletree (middletree_at_htomail.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 09:49:04 -0600

This may be a SQL error, but I suspect it's a connection string problem,
hence my posting it here.

I have an Intranet app at the company I work for. It's classic ASP, and
connects to a SQL Server 2000. Both the production version and my dev
version run on Win2K server boxes, with both the code and the database on
the same machine.

I wanted to set up the same app on my computer at home. My spare one,
actually, which has Win2003 as the OS. I made the alterations to IIS to
allow ASP, which is turned off by default.

When I go to any page which has an SQL query, say to build a dropdown box, I
get an ASP 0113 error. ASPfaq.com tells me that it's a timeout.

I know that the ASP code itself is running fine. That is, I can do a
response.write. But anything database related is failing with this error.

Here's my connection string, from an include file:

====================================
Dim strDBConnection
strDBConnection = _
        "Provider=SQLOLEDB;" & _
        "Persist Security Info=False;" & _
        "Data Source=w2003;" & _
        "User ID=deleted;" & _
        "Password=deleted;" & _
        "Database=deleted;"

Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
=======================================

Obviously, I deleted my ID, PW, and DBName for this post. Besides that, the
code is exactly the same as on my dev box, which works, and my home box,
which doesn't.

I should add that I changed DataSource in this string on my home box to the
Windows name of the machine, which is w2003. When I open up Enterprise
manager, it just says "local", but I guessed that I couldn't put the word
local there.

OK, I think I have all the relevant info in this post. Anyone have any
ideas?

Relevant Pages

  • ASP.NET 2005 connection string
    ... I've been programming in classic .asp and am looking into moving ... Should I put the connection string to our SQL ... I need to be able to have individual SQL ... login screen to capture the user's SQL login info and then pass these into ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • ASP vs ASP.NET connecting to SQL Server
    ... When I run a ASP.NET application against SQL ... However when I run an ASP application against the same SQL Server it ... For the ASP.NET application I have the connection string in the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: ASP, looping, and stored procedures.... error 800a0bb9 ...
    ... > page PER loop. ... The looping goes by month from and to dates selected ... > In pure ASP the page takes about 15 seconds. ... > Oh, and by the way, the test box has SQL server and IIS on it. ...
    (microsoft.public.inetserver.asp.db)