Hi,

I need some help please, I have set up a test MySQL dbase on my hosted webspace, the web server is running Linux and Chiliasp. The test ASP script I am trying to run is :

<%
on error resume next
dim adoConn
dim adoRS
dim counter
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "Driver={mySQL}; Server=localhost; Database=dbscratch3db; Uid=dbscratch3; Pwd=wentworth;"
adoRS.ActiveConnection = adoConn
if adoConn.errors.count = 0 then
response.write "<h2>Fields In The 'tblscores' Table:</h2>"
adoRS.Open "describe tblscores"
while not adoRS.EOF
response.write adoRS.fields(0).value & "<br>"
adoRS.MoveNext
wend
else
response.write "ERROR: Couldn't connect to database"
end if
%>

THis script works fine on my local setup of W2K, IIS and MySQL however when I run it on my hosted web space I get this error :

Active Server Pages error 'ASP 0113'
Script timed out
/asp10/testcon.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeOut or by changing the value in the ASP administration tools.

Could anyone help please.

Thanks

Les

at the top of your asp page put

Server.ScriptTimeOut = 3600

Thanks for the info,
But putting Server.ScriptTimeOut = 3600 at the top of the script doesnt fix the problem.

Les