What to do about errors returned by odbc

I am running 8.0.3 database with 7.4 odbc.

I am working on getting my ASCII over to Unicode so I can use the newer
odbc.

I get on a too often basis the ODBC lock up on the IIS server (I can re-boot
IIS and see ODBC come back).

The machine is not out of memory (4 gig Dell running win2k, database is on a
8 gig redhat box).

Unfortunately I display the error returned from the object and it includes
the text "Catastrophic Error".

This has been bad and I need to fix it, but I believe if I understand my
initial research it is actually an error from MS (either IIS or the ODBC
layer).

Since it does not appear to be a memory issue (last time I had it happen the
machine was at 500 meg of 2 gig used by IIS) I am looking for ideas as what
to look for.

Our application was on MSSQL and did not have errors with the odbc (servers
were very stable) to MSSQL.

I have us converted and eliminated most of the application type errors from
the conversion, but the odbc to postgres I think is our issue (may be how we
have it coded).

I am not using any kind of pooling (not sure if IIS does this on its own as
I do not see a million connections and we generally have 200+ concurrent
users).

Any ideas I can research would be greatly appreciated.

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin(at)wazagua(dot)com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.