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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
