Comments (6)
Which OS is this? If isql
works and pyodbc
doesn't suggests they maybe using different drivers, if driver manager can open one but not the other. Which driver did you specify in isql
?
from pyodbc.
i am using ubuntu 20.04 os and i had called same driver for both isql and pyodbc.
from pyodbc.
my odbcinst.ini files has
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/usr/lib/libmsodbcsql-17.so
UsageCount=1
[ODBC Driver For MySQL]
Description=ODBC Driver For MySQL
Driver=/usr/lib/x86_64-linux-gnu/libmyodbc8a.so
UsageCount=1
[mysql]
Driver=/usr/lib/x86_64-linux-gnu/libmyodbc8a.so
UsageCount=1
[MySQL ODBC 8.3 Unicode Driver]
DRIVER=/usr/local/lib/libmyodbc8w.so
UsageCount=1
[MySQL ODBC 8.3 ANSI Driver]
DRIVER=/usr/local/lib/libmyodbc8a.so
UsageCount=1
and odbc.ini has
[test]
Driver=mysql
SERVER=10.10.13.7
USER=root
PASSWORD=Super@dm1n
DATABASE=backoffice
PORT=3306
now when i use isql test, db connection is successful and when i am calling same driver from pyodbc, it gives me
pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc8a.so' : file not found (0) (SQLDriverConnect)") error.
from pyodbc.
I don't know if that is helpful, but I had pretty much the same issue and somehow got it working now.
Though, first isql wasn't working, too. But after I did install one additional library package and also did set LD_LIBRARY_PATH correctly for the driver, isql was working. Pyodbc still not.
I then checked the installed version of pyodbc, which was 5.1.0 (installed yesterday via pip) and tried to downgrade it to 4.0.93. Then it suddenly worked.
But strangely, after upgrading pyodbc again, first to 5.0.1 and then to 5.1.0, it still works.
This confuses me… I don't think I have done anything other than using "pip install" between the last unsuccessful and the later successful tests...
from pyodbc.
I don't know if that is helpful, but I had pretty much the same issue and somehow got it working now. Though, first isql wasn't working, too. But after I did install one additional library package and also did set LD_LIBRARY_PATH correctly for the driver, isql was working. Pyodbc still not.
I then checked the installed version of pyodbc, which was 5.1.0 (installed yesterday via pip) and tried to downgrade it to 4.0.93. Then it suddenly worked. But strangely, after upgrading pyodbc again, first to 5.0.1 and then to 5.1.0, it still works. This confuses me… I don't think I have done anything other than using "pip install" between the last unsuccessful and the later successful tests...
What was the one additional library package that you installed? isql isn't working for me too.
from pyodbc.
What was the one additional library package that you installed? isql isn't working for me too.
I'm not sure anymore, but I think in my case it was one of those: libaio1, libodbc2, libodbcinst2
But that could depend on which ODBC driver you want to use.
Best is to check with ldd /path/to/odbc/driver.so
if anything is listed as "not found".
from pyodbc.
Related Issues (20)
- im('08001', '[08001] [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: The wait operation timed out.\r\n (258) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to 10.0.0.5\\MSSQL16.MSSQLSERVER,1454. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (258)')
- Raspberry Pi, Ubuntu 22.04 arm64 ODBC18 SSL error HOT 2
- Can't build release artifacts due to cibuildwheel issue HOT 11
- Linux openSUSE Tumbleweed connection to MariaDB stopped working with version 5.x.x HOT 12
- sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('08001', '[08001] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000102:SSL routines::unsupported protocol] (-1) (SQLDriverConnect)') HOT 1
- Connection is busy with results for another command (0) (SQLExecDirectW) HOT 3
- Transaction is not getting rolled back HOT 7
- MACOS 系统使用 HOT 4
- Memory leak when passing strings within table value parameter to stored proc HOT 9
- Add support for SQLTablePrivileges
- Login Timeout Error when connecting to Synapse database using pyodbc python library in Azure synapse notebook via Managed Identity HOT 1
- reference count encoding in the connect function HOT 5
- PyToCType uses internal function removed from Python 3.13 HOT 3
- I am trying to install pyodbc in MacBook Pro M3 chip - arm64. The drivers are installed succesfully for odbc 13,17 and 18. But pyodbc is not able to detect the drivers.:
- I am trying to install pyodbc in MacBook Pro M3 chip - arm64. The drivers are installed succesfully for odbc 13,17 and 18. But pyodbc is not able to detect the drivers. ERROR: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") HOT 5
- Executing multiple queries HOT 1
- pyodbc.connect() gives an error when executing it with pytest HOT 1
- InterfaceError: Data source name not found with pyodbc despite working with isql HOT 8
- Multiple threads querying same table takes a long time HOT 19
Recommend Projects
-
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
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
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
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
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.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pyodbc.