I guess Merant ODBC driver depends on OCI library which is only available
after installed Oracle client. We use DataAnalyst from AgileInfoSoftware, we
use Microsoft ODBC Driver for Oracle and Oracle ODBC Driver, both need
Oracle client library be installed.
Eric.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, January 13, 2004 21:24
> Jeffrey,
> I've probably missed something, but if the application uses Merant's ODBC
driver - which I believe is a wire-protocol driver, how come you need to
install the client at all?
> Bruce Reardon
>
> NOTICE: This e-mail and any attachments are private and confidential and
may contain legally privileged information. If you are not an authorised
recipient, the copying or distribution of this e-mail and any attachments is
prohibited and you must not read, print or act in reliance on this e-mail or
attachments. This notice should not be removed.
>
>
> -----Original Message-----
> Sent: Wednesday, 7 January 2004 7:14 AM
>
> The application is a third-party application using Merant's ODBC driver.
>
> How do people normally install the client. Do you do an install to every
workstation???
>
>
> >>> jcave_at_cableone.net 1/6/04 2:54:34 PM >>>
>
> At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
> >Rather than installing the Oracle client on every client PC, we have
been:
> >- installing client on 1 PC
> >- copying directory to a network server
> >- extract the registry for "oracle" key
> >- fix registry that was extracted to reference the network drive
> >- load registry on client PCs
> >- add the network pc as a search drive to the client pc.
> >
> >We are now experiencing problems over the WAN and looking at ways to
> >eliminate the Oracle dll overhead. Short of installing Oracle on every
> >client PC, what are our options?
>
> There is a reason that Oracle doesn't support configurations like
> this. There is a fair amount of "chatter" between an application and the
> Oracle client DLL's. When this chatter starts flying over the network
> rather than merely going to a local DLL, you start to get performance
problems.
>
> How are your application(s) designed? It's probably possible to tweak an
> OCI application to make fewer OCI calls. If you're using ODBC, and have
> the budget, you could purchase one of the wire-protocol ODBC drivers.
>
> Justin Cave
> Distributed Database Consulting
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Reardon, Bruce (CALBBAY)
> INET: Bruce.Reardon_at_comalco.riotinto.com.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eric King
INET: erickingus_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Tue Jan 13 2004 - 20:54:34 CST
