This document will cover the use of Generic Connectivity which permits to connect oracle to a generic DB.
The main requirement is the availability of an odbc driver.

It is quite easy to find an ODBC on a windows system, not so much on a unix.

Connecting to a sqlserver 2000

This document describe one of the most troblesome configuration I have ever set up.
It took me almost two days to figure out how to properly set everything to make it works so I'm writing this documentation to spare a headache to other sysadmins/DBA who wish to achieve the same.

I divided the process in three steps: