CODEWITHSUNDEEP
oracle-databaseodbcdns
lemunk
lemunk

Reputation: 2636

Oracle ODBC dns connection

My boss has asked me to set up a connection to our oracle Database (not local).

My first step was to download a oracle ODBC driver to use.

I downloaded and installed "ODBC Driver for Rdb, Release 3.3.2.0 64-bit (odbc3320_64.zip)".

I then decided to set up the DNS as I have done before using ODBC manager in windows 7.

Unfortunatly its not as easy as setting up a connection to a sql server.

Im wondering could some one walk me through the process or has anyone got a video link?

Many thanks

heres TNSPING result

enter image description here

Upvotes: 0

Views: 4632

Answers (1)

Justin Cave
Justin Cave

Reputation: 231811

Assuming that you are trying to connect to an Oracle database, not an Oracle RDB database (RDB is a database that Oracle the company acquired from DEC), and assuming that the Oracle database is a reasonably recent version, and assuming that you do not have a version of the Oracle client installed on your machine now, the simplest approach is likely to download and install the 11.2 Oracle client on your machine and to choose to install the Oracle ODBC driver as part of that installation.

If you look at the Oracle Database Software Downloads page, under Oracle Database 11g Release 2, there will be a set of links for both 32- and 64-bit Windows. Choose the "See All" option for whatever version of Windows you have. That should give you an option to download something called the "Oracle Database 11g Release 2 Client" which is going to be a ~600 MB download. Once you have that, run the installer and make sure to include the Oracle ODBC driver as part of the installation (you may need to do a custom install, I don't recall which of the client installation options includes an ODBC driver by default).

Upvotes: 2

Related Questions