🚀 go-pugleaf

Yep, your remote machine needs to have either the Microsoft OLDDB or ODBC
driver for Oracle, which I think is a standard driver included in Windows,
but probably needs to be updated (see http://www.microsoft.com/data/ ). You
then need to get into the Control Panel, select ODBC, and assign a
connection string to your Oracle server.

Then you can use ADO, DAO, or whatever to connect to the Oracle server
through the connection string you assigned in the ODBC driver.

From then on, I BELIEVE you talk to Oracle in much the same way as talking
to Access or SQL Server... However I'm sure there's minor but very annoying
differences and omissions!!!

Charlie Barrett

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Help find E.T. with SETI@Home!!!

Does your PC get bored while you're away? A CPU is a terrible thing to
waste, so take him to http://setiathome.ssl.berkeley.edu/ and tell him to
download SETI@Home, the free, totally "Techno-Cool" screen saver.

Instantly, he'll be a PC with a mission, because SETI@Home is definitely is
NOT another "Flying Toaster" screen saver that rots his CPU. Your PC will be
processing Radio Telescope signals from Arecibo, using state-of-the-art DSP
algorithms like FFT's and Correlators. Then it uploads the results back to
SETI (the Search for Extra-Terrestrial Intelligence)... I told you it was
cool!!!

And if your PC makes one of the most important discoveries of all time (a
signal from a distant civilization), he will be the envy of the Net, because
the SETI team will give him credit in their worldwide press release (oh
yeah, you'll get credit, too, so you won't get jealous and make a scene).

Deja User <dejacom@my-deja.com> wrote in message
news:7pa03a$p0s$1@nnrp1.deja.com...
> Does anyone know how to access Oracle from a remote machine without
> having to have the Oracle Client software on the client machine? Is ADO
> the answer?
>
> Thanks and Regards,
> Phil
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

On Mon, 16 Aug 1999 21:33:30 GMT, Deja User <dejacom@my-deja.com>
wrote:

>Does anyone know how to access Oracle from a remote machine without
>having to have the Oracle Client software on the client machine? Is ADO
>the answer?
>
>Thanks and Regards,
>Phil
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

From what I understand, even the ODBC driver requires the Oracle
client software installed. I believe that even ADO uses ODBC for
foreign (non-Microsoft) system access.

Ken

i don't think this is completely correct, but i am mixing environments in my
defense... from what i learned, the ODBC sits on top of a SQL*Net layer...
w/out that layer, ODBC can't make the connection...
with ADO, we didn't have to use the ODBC driver, but we still needed the
lower layer (but in this case, we were using MSSql and it's stuff - not it's
ODBC, tho)... maybe we were doing something wrong, but it always required
the sql dll (forget the name, but it's what showed up when setting up the
client in MSSql)....

i may be wrong, but we never got this to work w/out the native connectivity
s/w, sqlnet or whatever....

good luck!
brent

Charlie Barrett wrote in message
<76Vu3.13894$vu2.3852@news.rdc1.tx.home.com>...
>Yep, your remote machine needs to have either the Microsoft OLDDB or ODBC
>driver for Oracle, which I think is a standard driver included in Windows,
>but probably needs to be updated (see http://www.microsoft.com/data/ ). You
>then need to get into the Control Panel, select ODBC, and assign a
>connection string to your Oracle server.
>
>Then you can use ADO, DAO, or whatever to connect to the Oracle server
>through the connection string you assigned in the ODBC driver.

In article <37bc31cc.11789598@news.cadvision.com>, krachyn@cadvision.com says...
> On Mon, 16 Aug 1999 21:33:30 GMT, Deja User <dejacom@my-deja.com>
> wrote:
> 
> >Does anyone know how to access Oracle from a remote machine without
> >having to have the Oracle Client software on the client machine? Is ADO
> >the answer?
> >
> >Thanks and Regards,
> >Phil
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
> 
> From what I understand, even the ODBC driver requires the Oracle
> client software installed. I believe that even ADO uses ODBC for
> foreign (non-Microsoft) system access.
> 
> Ken
> 
Actually Microsoft created their own OLE DB Provider for Oracle but
it still uses the SQL*Net of Version 7.3 or better (Version 2 of SQL*Net).
You can use ODBC to access Oracle via ADO but I have had better luck 
with the MS drivers.

Mike Mattix
dmmattix@earthlink.net