8i is desupported, that's true, but when running this old release I think you do not really take care about supported releases. Unfortunately you didn't state on which platform your 8i is running. Maybe you could use HSODBC in 8i which was shipped on some platforms like Windows, Solaris, HP-UX and AIX. So that might be an option for you. The other alternative would be to change the driving site and let SQL Server fetch the data. Just in that case you only need to install a compatible Oracle client on the SQL Server box (compatible means certified for the OS where the SQL Server is running and also a client that can connect to the old 8i database) which contains the ODBC driver and/or the OLEDB driver and then connect to the Oracle database from the SQL Server using SQL Server Linked Server mechanism.