Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Connecting to Oracle over Internet

Re: [Q] Connecting to Oracle over Internet

From: CC <colette.chamberland_at_mail.state.ky.us>
Date: Wed, 05 May 1999 18:57:18 GMT
Message-ID: <7gq4ab$1pv$1@nnrp1.deja.com>


I suggest giving up - I've been trying to get odbc,ado,oracle,IIS to work together, however it hasn't been going too well!

In article <yx%X2.3698$u34.1331_at_news.rdc1.md.home.com>,   "Mike Rose" <mmrose_at_home.com> wrote:
> Andy,
>
> I have had experiences similar to Jerry's such as:
>
> Access -> ODBC -> SQL*Net (Firewall/T1) via Internet (Cable Modem)
> SQL*Net -> Oracle8
> and
> IE 4 (Firewall/T1) via Internet
> (T1) IIS 4 -> Business Objects (CORBA) -> SQL*Net -> Oracle8
>
> both could/would give good performance unless the Internet was slow. In this
> scenario only the speed of the network was a factor, not ODBC or even CORBA!
>
> Mike Rose
>
> mmrose_at_home.com
>
> <zaq42_at_yahoo.com> wrote in message news:7gplua$ji8$1_at_nnrp1.dejanews.com...
> > I've been tasked with connecting our web query system (uses Cold Fusion)
> to
> > an Oracle database, via the internet, that is ~18 hops away (another
> > company). The connection is quite slow.
> >
> > I can use SQL Plus and select table at a reasonable speed, considering the
> > architecture.
> >
> > In order to connect to the Oracle Db via our web application, I must use
> ODBC.
> > Using the web architecture, ODBC, and the 18 hops really break down when I
> > attempt to return 8 10-column records from a two table join (640,000 x
> 3000
> > records).
> >
> > I'm able to return 50 1-column records from a query against a 3000 record
> > table.
> >
> > Has anyone succuessful used ODBC & Oracle over the net? Does anyone think
> > this is a viable option for us...or do I just need to give up this ODBC
> crap
> > (please say give it up).
> >
> > Thanks in Advance!
> >
> > Andy Carter
> >
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 13:57:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US