Hi, all.
I figured I'd ask the tremendously deep pool of intellect before I go postal on our
servers.
Earlier this week, we decided to implement OLEDB connections to SQL Server 7.0 SP2
instead of ODBC. But, we discovered the Cold Fusion wasn't pooling/reusing
connections, but instead was keeping the old connections open and opening entirely new
applications. We quickly reached the connection limit (of 1000!) and the only
recourse was to restart SQL Server or Cold Fusion (actually, the recourse would have
been to go back to ODBC, but we didn't know what the heck was going on).
Anyway, does anyone have experience with setting up OLEDB datasource to SQL Server 7.0
in Cold Fusion? We're running on Windows 2000 SP1 machines using CF 4.5.1 SP1. I
read and implemented Allaire's KB article about registering the sqloledb components,
but that didn't seem to help.
Anyone have any ideas or suggestions? I'd really like to move to OLEDB (if only to
eek out more performance from our aging hardware).
Thanks in advance!
Joe
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
