Thanks for the reply Jon.
I should have mentioned that the Frontpage tech that I am working with at
Microsoft has pretty much duplicated this issue on their system in that when
she sets the command timeout down to zero, it is ignored on her system as
well. (I don't think she had a query that would run longer than 30 seconds
so we couldn't duplicate the EXACT scenario on her system, but we have
established that the command timeout setting in Frontpage 2002 is broken)
Also, it's not the connection timeout that is a problem, my machine and the
sql server are on the same 100Mbit switch. It's the command timeout. I run
some tough datepart queries on a database that's about 1GB in size. If I use
an .asp file that I got from Microsoft (I think from their ASP department)
the query will run as long as it is set in the command timeout that is
specified within that file. However, if I let Frontpage build the .asp file
and the global.asa file, the command timeout specified in the global.asa
file is completely ignored.
You should be able to duplicate this issue on your own system by setting the
command timeout, in the Frontpage 2000/2002 GUI, for one of your databases
to be zero or 1 second, then try running a query that takes longer than 1
second, using an .asp page that Frontpage built, and you will see that it
will complete, when it should not. Also, if you have a query that takes
longer than 30 seconds, it will never complete due to the command timeout
setting being ignored.
Thanks for taking the time to reply.
"jon spivey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> obviously it shoudn't take 30 seconds to connect to a SQL Server - even if
> it was located at the other side of the planet. To try and narrow the
> problem down can you put up a page with this code -
> <%
> set oConn = server.createobject("adodb.connection")
> oConn.open
> "provider=sqloledb;server=10.10.10.10;database=yourdb;uid=you;pwd=secret"
> %>
> replacing 10.10.10.10 with the ip of your sql server and the uid and pwd
as
> appropriate. This should help us establish if the problem is with your sql
> server or fp or your network connection.
>
> --
> Jon
> Microsoft MVP - FP
>
> "Jace" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thanks for the reply, unfortunately, the command timeout setting in
> > Frontpage 2000 / 2002 are broken...
> >
> > Thanks anyway.
> >
> > "Harikumar" <(E-Mail Removed)> wrote in message
> > news:457DC88A-1EE1-4D1C-9E72-(E-Mail Removed)...
> > > CAUSE: the Query was timing out because the default command timeout of
> the
> > > connection (30 seconds) was shorter that the amount of time the query
> > needed to
> > > execute
> > > RESOLUTION:
> > > - Add an index to the table and that speed the query up so that it
did
> > not time
> > > out.
> > > - Customer could also change the command timeout in front page by:
> > > 1. Select insert database results
> > > 2. Use a new database connection and click create
> > > 3. Select connection and hit modify button
> > > 4. Make sure system datasource name is selected. If not select it
and
> > hit browse
> > > to select system DSN.
> > > 5. Click advanced and increase connection and command timeouts from
15
> > and 30
> > > respectively
> > > 6. Hit OK, then OK again
> > >
> >
> >
>
>
|
Similar Threads
