Re: 0113 timeout
From: Steven Burn (somewhere_at_in-time.invalid)
Date: 02/12/05
- Next message: Jeff Cochran: "Re: Why Classic ASP?"
- Previous message: Steven Burn: "Re: ASP CDONTS goes off screen"
- In reply to: middletree: "0113 timeout"
- Next in thread: middletree: "Re: 0113 timeout"
- Reply: middletree: "Re: 0113 timeout"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 12 Feb 2005 15:58:56 -0000
See if this helps........
Original URL:
http://groups.google.co.uk/groups?hl=en&lr=&threadm=OyOoxZAyEHA.2804%40TK2MS
FTNGP15.phx.gbl&rnum=2&prev=/groups%3Fq%3Diis%25200113%2520sql%2520%2522serv
er%25202003%2522%26hl%3Den%26lr%3D%26sa%3DN%26as_qdr%3Dall%26tab%3Dwg
And for future reference......
Original URL:
http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/p
roddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/stan
dard/proddocs/en-us/ref_we_asp.asp
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"middletree" <middletree@htomail.com> wrote in message
news:ujcL4EFEFHA.3972@TK2MSFTNGP15.phx.gbl...
> 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?
>
>
- Next message: Jeff Cochran: "Re: Why Classic ASP?"
- Previous message: Steven Burn: "Re: ASP CDONTS goes off screen"
- In reply to: middletree: "0113 timeout"
- Next in thread: middletree: "Re: 0113 timeout"
- Reply: middletree: "Re: 0113 timeout"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
