Sqlinstalldriverex failed with invalid install path | Компьютерный портал. Решение проблем в Windows.

Содержание

odbcinst: SQLInstallDriverEx failed with Invalid install path. #40
Comments
odbcinst: SQLInstallDriverEx failed with Invalid install path. about homebrew-mssql-release HOT 6 CLOSED
Comments (6)
Related Issues (20)
Recommend Projects
React
Vue.js
Typescript
TensorFlow
Django
Laravel
Recommend Topics
javascript
server
Machine learning
Visualization
Recommend Org
Facebook
Microsoft

odbcinst: SQLInstallDriverEx failed with Invalid install path. #40

Comments

Some days ago, my Mac OS 10.14 got some problem with ODBC SQL Server driver (before runs fine).

Now, shows in Python this message (‘01000’, «[01000] [unixODBC][Driver Manager]Can’t open lib ‘/usr/local/lib/libmsodbcsql.13.dylib’. I tested the library and exists in the path.

I tried to reinstall drivers (both 13 and 17) and the command microsoft/mssql-release/msodbcsql@13.1.7.0 returns odbcinst: SQLInstallDriverEx failed with Invalid install path.

Same issue for brew install msodbcsql17

I need some help. Tks

The text was updated successfully, but these errors were encountered:

The original message (File not found) is probably caused by a missing dependency, to debug that one I would need the output of the following:
otool -L /usr/local/lib/libmsodbcsql.17.dylib (or whatever the path is)

Also can you try to connect to server with «DYLD_PRINT_LIBRARIES=YES»? i.e
DYLD_PRINT_LIBRARIES=YES isql -k «DRIVER=;SERVER= ;UID= ;PWD=

As for reinstalling the drivers, I would suggest checking if they are still present, run the following:
odbcinst -j
If that works it’ll print something like:

Then cat the «Drivers» file, i.e.
/etc/odbcinst.ini
If this works it’ll output something like:

Check if the dylib is still there, if it is, proceed with the above debugging steps. If it isn’t try uninstalling the driver first and reinstalling it (unless that’s what you already did, then we can try to figure out what’s going on)

I would recommend focusing on Driver 17, there have been a lot of bug fixes since 13 and it has fewer dependencies

Hi, thanks for your very fast response. Results bellow:

Regarding otool:
Driver 13:
otool -L /usr/local/lib/libmsodbcsql.13.dylib
/usr/local/lib/libmsodbcsql.13.dylib:
/usr/local/opt/msodbcsql/lib/libmsodbcsql.dylib (compatibility version 1.5.0, current version 1.5.0)
/System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation (compatibility version 150.0.0, current version 1258.1.0)
/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
/usr/lib/libcurl.4.dylib (compatibility version 7.0.0, current version 8.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1226.10.1)
/usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
/usr/local/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0)
/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos (compatibility version 5.0.0, current version 6.0.0)
/usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current version 7.0.0)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0)
Driver 17:
/Library/Developer/CommandLineTools/usr/bin/objdump: ‘/usr/local/lib/libmsodbcsql.17.dylib’: No such file or directory

Regarding isql with DYLD_PRINT_LIBRARIES=YES
isql -k «DRIVER=;SERVER=xxxx;UID=xxxx;PWD=xxxx»
[ISQL]ERROR: Could not SQLDriverConnect

Regarding odbcinst -j
unixODBC 2.3.7
DRIVERS. /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES. /usr/local/etc/ODBCDataSources
USER DATA SOURCES. /Users/andresrecio/.odbc.ini
SQLULEN Size. 8
SQLLEN Size. 8
SQLSETPOSIROW Size.: 8

(Seems do not contains any driver, but when I will try new installation, shows the error bellow)

brew install microsoft/mssql-release/msodbcsql
==> Installing msodbcsql from microsoft/mssql-release
==> Downloading https://download.microsoft.com/download/4/9/5/495639C0-79E4-45A7
Already downloaded: /Users/andresrecio/Library/Caches/Homebrew/downloads/8f7c6834a87f6929b76418db93542d73395a5e5b9099c57d13a49e5991a8edab—msodbcsql-13.1.9.2.tar.gz
The license terms for this product can be downloaded from
https://aka.ms/odbc131eula and found in
/usr/local/share/doc/msodbcsql/LICENSE.txt . By entering ‘YES’,
you indicate that you accept the license terms.

Do you accept the license terms? (Enter YES or NO)
YES
==> odbcinst -u -d -n «ODBC Driver 13 for SQL Server»
==> odbcinst -i -d -f ./odbcinst.ini
Last 15 lines from /Users/andresrecio/Library/Logs/Homebrew/msodbcsql/02.odbcinst:
2019-12-19 07:50:11 +0100

odbcinst: SQLInstallDriverEx failed with Invalid install path.

If reporting this issue please do so at (not Homebrew/brew or Homebrew/core):
https://github.com/microsoft/homebrew-mssql-release/issues

Reviewing in another path (/usr/local/Cellar/msodbcsql@13.1.9.2/13.1.9.2) I found another odbcinst.ini, which contains;
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/usr/local/lib/libmsodbcsql.13.dylib

But /usr/local/lib/libmsodbcsql.13.dylib do not exists here.

Источник

odbcinst: SQLInstallDriverEx failed with Invalid install path. about homebrew-mssql-release HOT 6 CLOSED

Comments (6)

Can you check permissions of odbcisnt.ini?
ls -l /usr/local/etc/odbcinst.ini

Also can you check if libssl and libcrypto exist?
ls -l /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib

anreciomar commented on March 16, 2023 1

Hi v-makouz, after install Driver 17 (brew install msodbcsql17) works fine.

Summarizing, I made this operations:
->Permissions of odbcinst.ini was for root->change to «myuser» owner.
->libssl was in 1.1 version->update to Driver 17, because support both 1.0 and 1.1 versions.

Many thanks for your very kind helps.

v-makouz commented on March 16, 2023

Also can you try to connect to server with «DYLD_PRINT_LIBRARIES=YES»? i.e
DYLD_PRINT_LIBRARIES=YES isql -k «DRIVER=;SERVER= ;UID= ;PWD=

As for reinstalling the drivers, I would suggest checking if they are still present, run the following:
odbcinst -j
If that works it’ll print something like:

Then cat the «Drivers» file, i.e.
/etc/odbcinst.ini
If this works it’ll output something like:

I would recommend focusing on Driver 17, there have been a lot of bug fixes since 13 and it has fewer dependencies

anreciomar commented on March 16, 2023

Hi, thanks for your very fast response. Results bellow:

Regarding isql with DYLD_PRINT_LIBRARIES=YES
isql -k «DRIVER=;SERVER=xxxx;UID=xxxx;PWD=xxxx»
[ISQL]ERROR: Could not SQLDriverConnect

(Seems do not contains any driver, but when I will try new installation, shows the error bellow)

odbcinst: SQLInstallDriverEx failed with Invalid install path.

If reporting this issue please do so at (not Homebrew/brew or Homebrew/core):
https://github.com/microsoft/homebrew-mssql-release/issues

Reviewing in another path (/usr/local/Cellar/[email protected]/13.1.9.2) I found another odbcinst.ini, which contains;
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/usr/local/lib/libmsodbcsql.13.dylib

But /usr/local/lib/libmsodbcsql.13.dylib do not exists here.

anreciomar commented on March 16, 2023

Checking permissions on odbcinst.ini I check that had root permissions, set to «myself» user.
After this, launch the brew install and seems that this error do not exits:
brew install microsoft/mssql-release/msodbcsql
Updating Homebrew.
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> Updated Formulae
babel dashing exploitdb nethack teleport
bazel deployer futhark node terragrunt
calicoctl dlib grpc [email protected] [email protected]
crystal easyengine jenkins-lts snapcraft webpack

==> Installing msodbcsql from microsoft/mssql-release
==> Downloading https://download.microsoft.com/download/4/9/5/495639C0-79E4-45A7
Already downloaded: /Users/andresrecio/Library/Caches/Homebrew/downloads/8f7c6834a87f6929b76418db93542d73395a5e5b9099c57d13a49e5991a8edab—msodbcsql-13.1.9.2.tar.gz
The license terms for this product can be downloaded from
https://aka.ms/odbc131eula and found in
/usr/local/share/doc/msodbcsql/LICENSE.txt . By entering ‘YES’,
you indicate that you accept the license terms.

Do you accept the license terms? (Enter YES or NO)
YES
==> odbcinst -u -d -n «ODBC Driver 13 for SQL Server»
==> odbcinst -i -d -f ./odbcinst.ini
==> Caveats
If you installed this formula with the registration option (default), you’ll
need to manually remove [ODBC Driver 13 for SQL Server] section from
odbcinst.ini after the formula is uninstalled. This can be done by executing
the following command:
odbcinst -u -d -n «ODBC Driver 13 for SQL Server»
==> Summary
🍺 /usr/local/Cellar/msodbcsql/13.1.9.2: 9 files, 2.6MB, built in 5 seconds
Removing: /Users/andresrecio/Library/Caches/Homebrew/msodbcsql—13.1.5.0.tar.gz. (870.0KB)

and odbcinst.ini contains the driver:
MacBook-Pro-de-ANDRES:13.1.9.2 andresrecio$ cat /usr/local/etc/odbcinst.ini
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/usr/local/lib/libmsodbcsql.13.dylib
UsageCount=1

Regarding openssl libs, not found those versions:
MacBook-Pro-de-ANDRES:13.1.9.2 andresrecio$ ls -l /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
ls: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib: No such file or directory
MacBook-Pro-de-ANDRES:13.1.9.2 andresrecio$ ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib
ls: /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib: No such file or directory
MacBook-Pro-de-ANDRES:13.1.9.2 andresrecio$

But exists another versions:
-r—r—r— 1 andresrecio staff 2265596 15 dic 16:52 libcrypto.1.1.dylib
-r—r—r— 1 andresrecio staff 3930864 10 sep 15:13 libcrypto.a
lrwxr-xr-x 1 andresrecio staff 19 10 sep 15:13 libcrypto.dylib -> libcrypto.1.1.dylib
-r—r—r— 1 andresrecio staff 485860 15 dic 16:52 libssl.1.1.dylib
-r—r—r— 1 andresrecio staff 720400 10 sep 15:13 libssl.a
lrwxr-xr-x 1 andresrecio staff 16 10 sep 15:13 libssl.dylib -> libssl.1.1.dylib
drwxr-xr-x 5 andresrecio staff 160 15 dic 16:52 pkgconfig

Trying the connection, shows same message:

Error in Container (‘01000’, «[01000] [unixODBC][Driver Manager]Can’t open lib ‘/usr/local/lib/libmsodbcsql.13.dylib’ : file not found (0) (SQLDriverConnect)»)»

v-makouz commented on March 16, 2023

Driver 13 only supports OpenSSL 1.0, Driver 17 can work with either 1.0 or 1.1, so I would recommend trying to install Driver 17 again, as it seems like the odbcinst.ini permissions have been sorted out.

You mentioned that Driver 17 also wasn’t working with the same message, but it should be easier to trace as it has fewer dependencies

raise ImproperlyConfigured(«Error loading pyodbc module: %s» % e) django.core.exceptions.ImproperlyConfigured: Error loading pyodbc module: dlopen(/Users/jayyadav/Desktop/lms/lms_env/lib/python3.8/site-packages/pyodbc.cpython-38-darwin.so, 2): Symbol not found: _SQLAllocHandle Referenced from: /Users/jayyadav/Desktop/lms/lms_env/lib/python3.8/site-packages/pyodbc.cpython-38-darwin.so Expected in: flat namespace in /Users/jayyadav/Desktop/lms/lms_env/lib/python3.8/site-packages/pyodbc.cpython-38-darwin.so HOT 1
odbcinst: SQLRemoveDriver failed with Unable to find component name. HOT 9
Trap 6 Error connecting with PyODBC and wrong username or password HOT 4
Can’t get MSSQL/Pyodbc to work in brand new Macbook Pro HOT 5
Problems installing msodbcsql17 and mssql-tools HOT 3
Error trying to run homebrew-mssql formula in mac OS Big Sur (M1) HOT 4
I had the same error.
Could not connect to Azure SQL Database on version 17.8.1.1 HOT 1
My mac cannot connect to SQL Server on Windows Server 2012 R2 with Microsoft ODBC Driver 17 for SQL Server. HOT 5
Cannot tap microsoft/mssql-release: invalid syntax in tap! HOT 3
My Mac(m1) cannot install Microsoft ODBC 18 HOT 2
Cannot install/update Microsoft ODBC 18 on macOS 12 HOT 2
File not found error for MS ODBC SQL 13 on MacOS Catalina HOT 3
Download link for msodbcsql18 seems. down? HOT 2
This repo is missing important files
Codesign the drivers for use within Microsoft HOT 1
Can’t connect to the server HOT 6
Silent installs no longer possible HOT 6
[request] Add install option as alternative to ACCEPT_EULA envvar HOT 1
This repo is missing a LICENSE file

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.

Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

TensorFlow

An Open Source Machine Learning Framework for Everyone

Django

The Web framework for perfectionists with deadlines.

Laravel

A PHP framework for web artisans

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

Some thing interesting about web. New door for the world.

server

A server is a program made to process requests and deliver data to clients.

Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

Visualization

Some thing interesting about visualization, use data art

Some thing interesting about game, make everyone happy.

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.

Microsoft

Open source projects and samples from Microsoft.