we'd like to link an Oracle 9i database running on Unix to our sql server 2005 Business Intelligence server to import the data from the Oracle database. When we attempt to use the Microsoft ODBC for Oracle we get the error that the Oracle client and networking tools are not installed. When we attempt to use the Oracle RDB we get the error connection refused.
What steps do we need to do to connect the servers and run queries?
The Microsoft ODBC driver only provides full support for Oracle 7, and some limited support for Oracle 8 through emulation. It is unsupported for Orcale 9. You can see the roadmap for our data components via: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnmdac/html/data_mdacroadmap.asp. Please contact Oracle for their ODBC driver. Thanks
No comments:
Post a Comment