Re: Mayday! Mayday! Ora73 ODBC trouble!

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/11/25
Message-ID: <01bcf96a$2fd3f1c0$f3040059@billyv.vslabs.co.za>#1/1

Chris Fenstermaker <fensterm_at_comp-lett.com> wrote in article <01bcf8ca$4b564b00$1d150180_at_fe12405>...

> Mayday! Mayday! Ora73 ODBC trouble!

Reading you charlie foxtrot. Jettison MFC and ODBC, I repeat jettison MFC and ODBC. :-)

> 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)

 <snip>
> Are there better drivers out there than the ones from Oracle?

My experience with Oracle ODBC drivers can also be summed up into one word - bad. Some people mentioned that the latest Oracle driver from Microsoft behaves better. It can be downloaded as part of something or the other from Microsoft's web site. But, I've given up hope with ODBC and Oracle and has now turned to Delphi Client-Server using native Oracle SQL*Net. Borland supplies an OCI driver with Delphi C/S which works pretty well. My software seems to be a lot more stable and sql performance has also increased slightly (no more additional dll layers to go thru).

There's a couple of alternatives you can try:

- change from ODBC to OCI (Oracle Call Interface)
- use Pro*C (C precompiler for Oracle) and embedded SQL
- use another development language (like Delphi) that supports native

Oracle connections

> Does the Oracle DB have quotas on how many connections a user / remote
 node
> can have open at the same time?

No. A single user can make any number of connections - just make sure you have enough client licences. ;-)

regards,
Billy Received on Tue Nov 25 1997 - 00:00:00 CST