SQL Anywhere database - ODBC unstable in 9.0.2.3124+?

Author

ODBC unstable in 9.0.2.3124+?

Martin Baur

2005-06-19, 8:23 pm

Hi there

On our productive server, I installed 9.0.2.3124 EBF and since then I face every 10-14 days a freeze from ColdFusion MX 6.1. Websites using CF to connect over ODBC to ASA, simply return nothing more
to the client. ColdFusion has a ODBC Server Service. This one stalls and prohibits any database access. Restarting this service resolves the problem.

Because I only change the ASA engine on the productive server, I can tell that this ODBC freeze happens since EBF 3124 (and now 3133) is installed.

Any ideas?

Thanks

Martin

Nick Elson

2005-06-21, 9:23 am

> On our productive server, I installed 9.0.2.3124 EBF and since then I face
> every 10-14 days a freeze
> . . .
> Because I only change the ASA engine on the productive server, I can tell
> that this
> ODBC freeze happens since EBF 3124 (and now 3133) is installed.

What version were you using before? [the one that did not freeze up this
way]
And have you gone back to that to verify your assumptions are correct?

> This one stalls and prohibits any database access.

How do you measure ANY access here? Local to the database server
using dbisql?

"Martin Baur" <tinu@mindpower.com> wrote in message
news:MPG. 1d2005bab0d1e6b39898
0a@forums.sybase.com...
> Hi there
>
> On our productive server, I installed 9.0.2.3124 EBF and since then I face
> every 10-14 days a freeze from ColdFusion MX 6.1. Websites using CF to
> connect over ODBC to ASA, simply return nothing more
> to the client. ColdFusion has a ODBC Server Service. This one stalls and
> prohibits any database access. Restarting this service resolves the
> problem.
>
> Because I only change the ASA engine on the productive server, I can tell
> that this ODBC freeze happens since EBF 3124 (and now 3133) is installed.
>
> Any ideas?
>
> Thanks
>
> Martin

Sponsored Links