search

hashhashu / sqltools-Oracle-driver

SQLTools Driver for Oracle
MIT License
4 stars 1 forks source link

Doesn't recognize Oracle client (19.0.0) #5

Closed naris closed 1 year ago

naris commented 1 year ago

I get this error when I attempt to connect to an oracle DB. Even though I have the 64 bit version of the oracle 19.0.0 client installed and, in the path, (and working with SQL Developer, Java and other applications) it complains about not being able to find the client:

Error opening connection DPI-1047: Cannot locate a 64-bit Oracle Client library: "C:\Oracle\product\19.0.0\client_1\bin\oci.dll is not the correct architecture". See https://oracle.github.io/node-oracledb/INSTALL.html for help Node-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html You must have 64-bit Oracle Client libraries in your PATH environment variable. If you do not have Oracle Database on this computer, then install the Instant Client Basic or Basic Light package from https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html A Microsoft Visual Studio Redistributable suitable for your Oracle client library version must be available.

The current version of the oracle client is 21.8.0.0, which is compatible will all older versions of the server. It looks like this was tested with oracle 11.2.0 which went end of life on March 31, 2021 :(

naris commented 1 year ago

Never mind, downloading and extracting the 64 bit 21.8.0 instant client seems to of resolved the issue. The 19.0.0 client must of been 32 bit or something.