Re: How do I setup an Oracle odbc connection

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 14 Jul 2001 21:00:06 +0100
Message-ID: <9iq884$615$1@plutonium.btinternet.com>

In control panel go to ODBC connections and create a new DSN for the database. You have to have an Oracle ODBC driver installed. When adding a new connection in the control panel look in the list if one is available. If not go to technet.oracle.com to download the Oracle ODBC driver (Microsoft has a free one too).

Create a database alias for the Oracle database using Net8 assistant (prev known as the SQL*Net easy configuration utility).

That should be it.

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"Alexander Raiano" <raianoat_at_yahoo.com> wrote in message
news:48838a8e.0107130917.34ca7eb2_at_posting.google.com...


> Hi all,

> How do I setup an odbc connection to an Oracle db?  The db that I want

> to connect to is running on a Solaris box.  The client that I will be

> connecting from will also be a solaris box.  What are the

> configuration file that I have to touch?

>

> Thanks in advance,

> alex

Received on Sat Jul 14 2001 - 15:00:06 CDT