First, I'm sure you are aware that Oracle v9 products have been desupported for a long time. Also, since this thread was opened all the v10 gateways are now desupported and have been replaced by the 11g Database Gateways.
These are certified with Oracle 9i RDBMS as long as it is at 9.2.0.8 and which has had patch 5965763 applied.
The good news is that the 11g Database Gateway for SQL*Server (DG4MSQL) is now available to run standalone on Unix platforms, so you you could install that on the same machine as your RDBMS in a separate ORACLE_HOME and use that to access SQL*Server.
You could also use the 11g Database Gateway for ODBC (DG4ODBC) which needs a third party ODBC driver but can also be used standalone. DG4MSQL needs a license but Dg4ODBC is included in your RDBMS license.
Of course, you can also install either of these standalone on a Windows machine and access from your 9i RDBMS on Unix.
See the following notes on My Oracle Support for details -
Note.466228.1 How to Setup DG4ODBC on Linux x86 32bit
Note.561033.1 How to Setup DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX)
Note.466225.1 How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit
Note.437374.1 How to Setup DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11 on Linux
Note.466267.1 How to Setup DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit
Note.1086365.1 How to Setup DG4MSQL (Database Gateway for MS SQL Server) on a 64bit Windows
Note.562509.1 How to Setup DG4MSQL (Oracle Database Gateway for MS SQL Server) 64bit Unix OS (Linux, Solaris, AIX,HP-UX)
No comments:
Post a Comment