search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.49k stars 300 forks source link

Error opening connection DPI-1050: Oracle Client library is at version 11.1 but version 11.2 or higher is needed #480

Closed doberkofler closed 4 years ago

doberkofler commented 4 years ago

When trying to connect to a local Oracle database the driver reports the following error: Error opening connection DPI-1050: Oracle Client library is at version 11.1 but version 11.2 or higher is needed

The configuration is as follows:

{
    "sqltools.connections": [
        {
            "connectionTimeout": 30,
            "database": "TEST",
            "dialect": "OracleDB",
            "name": "LJ_UNITTEST",
            "password": "***",
            "port": 1521,
            "server": "localhost",
            "username": "LJ_UNITTEST"
        }
    ],
    "sqltools.useNodeRuntime": true,
    "sqltools.languageServerEnv": {
        "ORACLE_HOME": "C:\\oracle\\product\\12.2.0\\dbhome_1"
    }
}
mickeypearce commented 4 years ago

What is your OS version? Do you have a ORACLE_HOME defined in system variables (apart from vscode settings)? Thanks for your answers.

mickeypearce commented 4 years ago

Take a look at this: https://github.com/oracle/python-cx_Oracle/issues/351#issuecomment-538785431

Oracle client 18 and 12.2 require the Visual Studio 2013 Redistributable.

mickeypearce commented 4 years ago

@doberkofler did you solve the problem? Can you please provide the details, how did you do it, thanks.

doberkofler commented 4 years ago

Sorry for just closing without commenting. I just wanted not to use more of your time. After having tried to install on another Workstation it worked as expected, so I concluded that something was just messed up and I need to sort this out by reinstalling everything from scratch.

mickeypearce commented 4 years ago

No problem. Good luck. 😄