Article View: comp.lang.basic.visual.database
Article #8Re: Oracle WITHOUT client s/w.....How? (ADO ???)
From: Charlie Barrett
Date: Thu, 19 Aug 1999 00:00
Date: Thu, 19 Aug 1999 00:00
47 lines
3113 bytes
3113 bytes
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.
Technical Details
Message-ID:
<76Vu3.13894$vu2.3852@news.rdc1.tx.home.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7pa03a$p0s$1@nnrp1.deja.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10de66,775bf386f6d40599 X-Google-Attributes: gid10de66,public X-Google-Thread: f99a8,775bf386f6d40599 X-Google-Attributes: gidf99a8,public X-Google-Thread: 105516,775bf386f6d40599 X-Google-Attributes: gid105516,public X-Google-Thread: 1143a7,775bf386f6d40599 X-Google-Attributes: gid1143a7,public From: "Charlie Barrett" <charliebarrett@home.com> Subject: Re: Oracle WITHOUT client s/w.....How? (ADO ???) Date: 1999/08/19 Message-ID: <76Vu3.13894$vu2.3852@news.rdc1.tx.home.com> X-Deja-AN: 514711947 References: <7pa03a$p0s$1@nnrp1.deja.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 X-Complaints-To: abuse@home.net X-Trace: news.rdc1.tx.home.com 935075331 24.5.52.10 (Thu, 19 Aug 1999 08:08:51 PDT) Organization: @Home Network X-MSMail-Priority: Normal NNTP-Posting-Date: Thu, 19 Aug 1999 08:08:51 PDT Newsgroups: comp.lang.basic.visual.database,microsoft.public.ado,borland.public.delphi.database.sqlservers,comp.databases.oracle.misc