Hi Bo,
We have reported this problem to Merant and they claim it will be fixed
in their ODBC 3.7 release, which will be part of CF 5.0 starting with
Beta 2 (beta 1 will be out in 1-2 weeks).
You are correct in stating that it occurs when waiting for a long query
or stored procedure. Our guess is that Merant put in some hard timeouts
where they shouldn't.
Sorry this doesn't solve your problem in the short term.
--
Tom Jordahl
Allaire Development
Bo Daley wrote:
> hi everyone,
>
> I'm in the process of moving a CF site across from IIS/WinNT to Apache/Linux
> (aren't we
> all) and I'm running into an intermittent error with connections to the
> database server (MSSQL7 on WinNT4).
>
>
>
> ODBC Error Code = 01000 (General warning)
>
> [MERANT][ODBC SQL Server Driver][libssclient15]ConnectionRead (select()).
>
>
>
> The error only seems to affect queries and storedprocs that take more than
> around 10 seconds to return results from the DB (even though the Connection
> Timeout is set at 2 mins in CFAdministrator...), but it doesn't occur
> regularly enough to really pin down a common cause...
>
> There's a thread about this in the forums, but no pointers to any solutions
> as yet...:
>
> http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=588700&_#Message58
> 8700
>
> Anyone else encountered this problem?
>
> bo.
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
