Re: Help with installing MS ODBC for Oracle

i have had much luck just using the oracle client cd.... you do not really need SQL*Plus, dont need DCOM, or much documentation....it's easy, swear.

if you load the Oracle client, you will have SQL*Net and Oracle's ODBC driver... that is all you need....

add a System Data Source, name it something straightforward like Oracle, and enter the TNSNames entry for your box - eg, Connect: MYOracleBox (where MYOracleBox is the paragraph header that points to your server- dont need the .WORLD part)...

that is it, senor.... when you want to connect using Excel, just specify your Oracle ODBC source - that is it, except the user / password stuff....

feel free to email me, i can help if you want....

brent douglas, ncr

argosy22_at_my-deja.com wrote in message <7nn5n5$1g$1_at_nnrp1.deja.com>...
>Hello,
>
>We are running:
>- Windows 95 clients (some 98, and NT)
>- Oracle 7.3.4
>- Sqlnet
>
>I have what should be a very simple scenario.
>
>We have installed Oracle's (7.3.4) Sqlplus on
>all our workstations. Now, we just want to
>be able to connect to the database via Excel
>and VB. This means ODBC.
>
>I have been getting VERY inconsistent results
>accross workstations.
>
>We want to:
>- download the correct Microsoft ODBC for Oracle driver
>- install it
>- create some consistent ODBC connections
>- query the database via Excel
>
>
>Searching the Microsoft site, there is no end
>to MDAC articles. Some of these articles say
>that, first we must now also install DCOM onto
>the clients. I haven't started reading about
>DCOM very much yet, but I fear that this will
>in turn have a huge list of things to read
>about and be aware of, and that we must also
>install other things on the workstations.
>
>
>Has anyone done the above? Can anyone give me a
>simple process to accomplish it?
>
>Does the driver not work on 98?
>
>
>Thanks in advance,
>
>Argosy
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 13:26:02 CDT