I believe the technical term is f'n magic. It is pretty much the analog of the JDBC thin client drivers - i.e. one that doesn't require the Oracle client software and communicates directly over TCP (not sure if any support anything else) with the db server.
They cost. Niall > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jared Still > Sent: 06 January 2004 20:45 > To: Multiple recipients of list ORACLE-L > Subject: Re: oracle client on PC's > > > What is a 'wire-protocol' ODBC driver? > > Jared > > On Tue, 2004-01-06 at 11:54, Justin Cave wrote: > > 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: Justin Cave > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > 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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] 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: [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).
