Database Results Error Description: [Microsoft][ODBC SQL Server Driver]Timeout expired

[Jace]

I have been getting this error:

"Database Results Error
Description: [Microsoft][ODBC SQL Server Driver]Timeout expired
Number: -2147217871 (0x80040E31)
Source: Microsoft OLE DB Provider for ODBC Drivers"

for some time now and have contacted Microsoft FrontPage paid support. I
have been on the phone with a tech for about 5 hours and still do not have
an answer. I am using FrontPage 2002, IIS 4.0 and SQL Server 7.0 SP4.

The tech is forwarding the issue as a Request for Comment, whatever that is.
I think the answer is that FrontPage 2000 and 2002 are broken and not
setting the CommandTimeout line properly.

Has anyone else seen this issue?

Thanks!

 

[Jim Buyens]

I can only offer this generic advice.
1. Verify that you have network connectivity between the
server running iIS and the server running SQL.
2. Verify that other applications on the same machine
can access the database.
3. Check the username and password.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*========----------
|\=========------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/=========------------
*========----------