Re: ODBC Connections Bad?

Walter,

I wouldn't go so far as to say that ODBC is bad in all cases, but it does leave something to be desired also. In the past I have noticed that ODBC connections stay connected to the database until the application is closed. To clarify this, suppose a user opens Access and opens an Access db with reports that use ODBc to query Oracle. They run their reports and get their information. They close the db and open another small application db that has no connection to Oracle. The ODBc connection to the Oracle db will persist until they actually EXIT Access completely. This same behaviour exists with Excel and pulling data into spreadsheets.  The other aspect is performance of the ODBC driver itself. ODBC drivers delivered by Microsoft tend to be incredible hogs. Intersolv used to produce a much better driver, but it isn't free. Oracle's driver used to perform somewhere in the middle. I don't have any metrics of the current drivers, this is on my past experience with them.

HTH Rodd Holman

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/10/01, 2:06:40 PM, Walter K <alden14004_at_yahoo.com> wrote regarding ODBC Connections Bad?:

> I have been told in the past that ODBC connections to
> the database are slow and very resource intensive, but
> unfortunately this was not explained. Fortunately, I
> haven't really had to deal with ODBC connections much.

> However, in my new job, several users are using MS
> Access as their query tool and it looks like the
> number is growing.

> So, are ODBC connections to the database really slow
> and a resource problem? If so, why? Also, is there
> anything special in regards to the database that I
> should be watching or tuning outside of the norm just
> because I have a bunch of Access users hitting the
> database?

> Thanks again for the assistance!
> -w

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).