Unanswered: [help] Oracle 10g publisher to SQL Server 2005
Can someone assist me? I am running a Publishing Service on Oracle 10g.
I am trying to set up a Distributor on SQL Server2005.
When I try to connect, I get this error:
Oracle Server Instance 'foobar' cannot be enabled as a Publisher because of the following error:
Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor. For additional information, see SQL Server Error 21617 in Troubleshooting Oracle Puiblishers in SQL Server Books Online. (Microsoft SQL Server, Error: 21617)
The online help says that I need to make sure that SQLPLUS is correctly set in the path, which it is. I can connect to Oracle with SQL PLUS just fine, and I can run it from anywhere, since it is indeed in the path.