Skip to content

pyodbc to MSSQL connectivity from Anaconda venv #1157

Answered by gordthompson
AASupport123 asked this question in Q&A
Discussion options

You must be logged in to vote

When running in the virtual environment, Python was loading a venv-specific version of libcrypto.so.1.1 from

/home/nmogalap/.conda/envs/test14/lib/python3.9/lib-dynload/../../libcrypto.so.1.1

instead of using the "system" version from

/lib64/libcrypto.so.1.1

and that was causing pyodbc to fail. The fix was to adjust the venv to use the "system" version of libcrypto.so.1.1 by replacing the venv-specific version with a symlink:

$ cd /home/nmogalap/.conda/envs/test14/lib/python3.9/lib-dynload/../../

$ mv libcrypto.so.1.1 libcrypto.so.1.1.old

$ ln -s /lib64/libcrypto.so.1.1

Replies: 9 comments 44 replies

Comment options

You must be logged in to vote
3 replies
@AASupport123
Comment options

@gordthompson
Comment options

@AASupport123
Comment options

Comment options

You must be logged in to vote
2 replies
@AASupport123
Comment options

@v-chojas
Comment options

Comment options

You must be logged in to vote
17 replies
@v-chojas
Comment options

@AASupport123
Comment options

@v-chojas
Comment options

@AASupport123
Comment options

@v-chojas
Comment options

Comment options

You must be logged in to vote
7 replies
@gordthompson
Comment options

@AASupport123
Comment options

@gordthompson
Comment options

@gordthompson
Comment options

@AASupport123
Comment options

Comment options

You must be logged in to vote
1 reply
@gordthompson
Comment options

Comment options

You must be logged in to vote
0 replies
Comment options

You must be logged in to vote
11 replies
@gordthompson
Comment options

@AASupport123
Comment options

@gordthompson
Comment options

@v-chojas
Comment options

@AASupport123
Comment options

Comment options

You must be logged in to vote
2 replies
@v-chojas
Comment options

@AASupport123
Comment options

Answer selected by gordthompson
Comment options

You must be logged in to vote
1 reply
@v-chojas
Comment options

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment