CF MX 7, Queries timing out, ODBC connectionstemporarily lost

[DFranch]

We have recently updated our test server to CF MX 7. It is a Pentium 2.8 GHz
with 1 gig of ram running Windows server 2003. Here is the problem, queries
will suddenly not be able to access any databases, and I receive an "Error
Executing Database Query.Timed out trying to establish connection " error. If
I go into administrator and try to verify all connections I get an error. If I
wait 5 - 10 minutes it usually comes back and everything works well (until it
happens again). I've seen many posts about this problem for MX 6.1, but only 1
or 2 for MX 7.0. Has anybody had any luck fixing this problem? Do any of the
hotfixes cure this problem?

Thanks for any help!

[sdupre]

What database are you using? MS SQL Server, Oracle, MS Access?

Do you set a connection pool size in the datasource (Limit connections)?

Another possibility is to get a
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18339[/url] to see
whta's running at the time you're getting timed out connections.

There's an odd chance the ODBC Server service is restarting, you might want to
check the event log and the /db/slserver54/logging/*.log for information.

Stephen Dupre
Macromedia QA

[DFranch]

The Databse is SQL Server 2000.

The limit connections setting is not set for any of the datasources.

I will try the stack trace the next time we have the problem.

The following error shown quite often in the event viewer:

the description for event id (0) in source (coldfusion MX 7 ODBC server)
cannot be found. the local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
you may be able to use the //AUXSOURCE = flag ro retrieve this description; see
help & support for details. the following information is part of the event:
coldfusion <C 7 ODBC Server@LOCALHOST. ErrorCode=2310, Errormessage=TCP/IP,
connection reset by peer.

When I look at the logs, The following appear frequently:

Thu Jun 16 14:54:16 2005:SLX ODBC Socket. Build 0097
Thu Jun 16 14:54:16 2005:SNYCFF(2 CPU) - Microsoft Windows 2000(5.2-Service
Pack 1 (Build 3790))
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Thu Jun 16 14:54:16 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer
Mon Jun 20 09:19:25 2005:TCP/IP, connection reset by peer

Mon Jun 20 09:40:13 2005:SLX ODBC Socket. Build 0097
Mon Jun 20 09:40:13 2005:Connection request from 127.0.0.1, client application
JDBC
Mon Jun 20 09:40:13 2005:SNYCFF(2 CPU) - Microsoft Windows 2000(5.2-Service
Pack 1 (Build 3790))
Mon Jun 20 09:40:13 2005:The specified data source is not defined.

[sdupre]

Are you using SQL Server for NT authentication purposes? The JDBC driver works with standard or enterprise and is much better.

Stephen Dupre
Macromedia QA

[DFranch]

We have 1 ODBC connection for our SQL server 2000 databases, We have another
ODBC datasource for an Oracle database (which does not belong to another unit),
and we have about half a dozen ODBC datasources for Paradox tables. The SQL
server and Oracle datasources could be switched to JDBC drivers, but while I
think there is a JDBC driver for paradox, we could never get it to work with
our tables.

[Dai Wei]

>but while I think there is a JDBC driver for paradox, we could never get it to work with our tables.
You can try HXTT Paradox at
[url]http://www.hxtt.net/en/software/paradox/start.html[/url] .

[DFranch]

I think it is the report builder. The problem seems to happen alot more
frequently when I am working on a report change. I have the report builder set
up to point to our test RDS server. If I try to build a query in the report
builder it causes the test server to hang (not all of the time, but frequently
enough to not be a coincidence) I have removed the test RDS server from the
report builder, hopefully this will rectify the problem.