ODBC for Oracle

Download the authoritative guide: Data Center Guide: Optimizing Your Data Center Strategy

Download the authoritative guide: Cloud Computing: Using the Cloud for Competitive Advantage

by Armand Datema

Note: I wrote this article with the help of our DBA, she had some information about this. Unfortunately she didnt know where she got the information from (the internet, a book etc., so if someone recognizes this dont go out shooting me, but let me know and I will give the proper credits. How to use ODBC with Oracle


In order to use ODBC and Oracle you need to have the Microsft Data Access Components 2.0 installed. If you dont have it yet, it comes with the full NT Optionpack 4 and can be downloaded seperately from Microsoft.

Install the Microsoft Data Access Components 2.0

It is best to choose the full installation, if you however choose the custom installation make sure that you select the following options:

  • ODBC Components
  • OLE DB Components
  • ODBC Driver for Oracle Database
  • OLE DB Provider for Oracle Database
  • Microsoft ActiveX Data Objects

Install Oracle client software and SQL*Net

  1. From the Oracle CD run the setup from the root directory (Note: if you are installing Oracle form a networkl drive, you must "Map a network drive" to install the software)
  2. Select language
  3. Select installation directorie

The software will now be installed and the setup will exit. Start it again and repeat the ebove steps.

  1. Select "Oracle Client Products"
  2. Select "Application User"
  3. Now choose if you want the dodcumentatation to be installed on the Hard Drive or read it from the CD

The setup program will now copy all the files and configure the client software

In order to connect to an Oracle Database using ODBC a valid SQL*NET connect string must be supplied. Unlike the normal ODBC setup for other databses like MS ACCESS you cannot name it directly. You must do this with the "SQL*NET easy configuration", it allows you to create an "alias" that you cna reference in an ODBC DSN to connect to the Oracle Server.

Create a Database Alias

  1. Run SQL*Net easy Configuration
  2. Select "Add Database Alias"
  3. Type in a name for the alias
  4. Select the protocol - usually TCP/IP
  5. Ask your DBA for the name of the server and the database on that server
  6. Specify the host machine(server) and database instance(database)
  7. Confirm the settings and select "Exit SQL*Net Easy Configuration"

Create a System DSN

  1. On the webserver add a new system DSN
  2. Select "Microsoft ODBC for Oracle"
  3. In the "microsft ODBC for Oracle" Dialogue supply the required information. Ask your DBA for the "User Name". "server" is the alias that was created with "SQL*Net Easy Configuration"
Data Source Name MyOracleDSN
Description optional
User Name  (ask your DBA)
Server (SQL*Net Easy Configuration alias)

Leave the options set to their default value.

The ODBC is setup now and you can start writing you asp apps :)

This article was originally published on Mar 15, 1999
Page 1 of 1

Thanks for your registration, follow us on our social networks to keep up-to-date