0113 timeout

[middletree]

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?

 

[Steven Burn]

See if this helps........

http://surl.co.uk/?1175

Original URL:
http://groups.google.co.uk/groups?hl=en&lr=&threadm=OyOoxZAyEHA.2804@TK2MS
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......

http://surl.co.uk/?1174

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]

See if this helps........

http://surl.co.uk/?1175

http://surl.co.uk/?1174

Both those links took me to the same place

All it does is list the various errors and a short description. In the case
of this error, it didn't tell me anything I didn't already get from
www.aspfaq.com. I know it's timing out. I think it's because my connecton
string is wrong. I was hoping somebody might be able to tell me if they see
something wrong that needs to be changed.