ODBC for Oracle
March 15, 1999by 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.
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:
Install Oracle client software and SQL*Net
The software will now be installed and the setup will exit. Start it again and repeat the ebove steps.
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
Create a System DSN
Leave the options set to their default value.
The ODBC is setup now and you can start writing you asp apps :)