Mayday! Mayday! Ora73 ODBC trouble!

I really *need* *help* with this...

We are using several Windows NT console mode and MFC applications which access
an Oracle73 database via ODBC (Oracle73 Drivers 1.15 and 2.5, Driver Mgr 3.0)

For some reason when the database server is down or not reachable the SQL[Driver]Connect blocks and does not return to the caller after the login timeout has expired.

On top of that even though I specified NO_PROMPT and supplied a NULL window handle
on SQLDriverConnect, the driver's login dialog pops up after a while if it cannot connect to the database.

Best of all even if the driver connects succeed, our apps sometimes hang all
night.

Are there better drivers out there than the ones from Oracle? (Already tried
Intersolv 3.01)
Are there SQL*NET V2 setting I ought to check? Does the Oracle DB have quotas on how many connections a user / remote node can have open at the same time?

Thank you in advance for helping out.

Chris

fensterm_at_comp-lett.com Received on Mon Nov 24 1997 - 00:00:00 CST