Hey everyone,
I'm in new territory and can use all the help that I can get.
Back in January, our school district installed a new server with SQL 2016 running on Windows Server 2012 R2. We also are hosting PowerSchool servers, which run on Oracle.
One of our older servers is running VB scripts, with the OraOLEDB.Oracle provider installed. Because of performance issues on the older server, it was decided to migrate the scripts from the older server to the SQL Server.
The problem is that the SQL 2016 server does not appear to have the OraOLEDB.Oracle provider installed. Typically, we would install the Instant Client Package - Basic file and the Instant Client Package - ODBC file on the end user's computer. I tried that, and the test connection works. However, upon running one of the VBS scripts, it came back with the error:
"Provider cannot be found. It may not be properly installed."
It has dawned on me that I may be on the wrong track.
Cutting right to the chase, how do I install the OraOLEDB.Oracle provider?