- How to install sql server client tools 2012 install#
- How to install sql server client tools 2012 driver#
Then I run the script and it throws out the "Provider cannot be found. (At this point, I can only assume that there is a working connection.)
How to install sql server client tools 2012 driver#
Under System DSN, created new data source (Oracle in instantclient_12_2)Ĭompleted Oracle ODBC Driver Configuration screen Unzipped and copied both products into the same directory C:\instantclient_12_2Įxecuted odbc_install using command prompt (in administrator mode) successfullyĪdded SYSTEM variable (not USER variables): Instant client package - obdc (as of this writing: version nt-12.2.0.1.0) Instant client package - basic (as of this writing: version nt-12.2.0.1.0) Just so that everyone is on the same page, on our SQL 2016 server: Mike Kutz wrote:Why have you not rewritten the VBS application with Oracle Application Express (APEX)īest answer I have for that is "Wait, we can do that?" PsConn.open "Provider=OraOLEDB.Oracle Data Source= User ID= Password= " Set psConn = createObject("ADODB.Connection") On our older servers, this worked without throwing out an error. I did test the connection on the ODBC Data Source Administrator (32-bit) the first time and the test connection was good.Īnother thought that recently crossed my mind was: "Am I using the correct connection string in my VBScript?" I will blow out the current Instant client installation and try again, using the Command Prompt as Administrator.
How to install sql server client tools 2012 install#
It may not be properly installed."This sounds like a bad installation.Did you run the installation as Administrator?Did you test that the install was correct prior to running the VBS app? Mike Kutz wrote:RedantJ wrote:"Provider cannot be found. It has dawned on me that I may be on the wrong track.Ĭutting right to the chase, how do I install the OraOLEDB.Oracle provider? However, upon running one of the VBS scripts, it came back with the error: I tried that, and the test connection works. Typically, we would install the Instant Client Package - Basic file and the Instant Client Package - ODBC file on the end user's computer.
The problem is that the SQL 2016 server does not appear to have 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. One of our older servers is running VB scripts, with the OraOLEDB.Oracle provider installed. We also are hosting PowerSchool servers, which run on Oracle.
I'm in new territory and can use all the help that I can get.īack in January, our school district installed a new server with SQL 2016 running on Windows Server 2012 R2. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 kommentar(er)
