Comments (4)
Hi Salma,
A couple pointers/questions:
- The
UTF- 8
portion in your connection string has a space, is that a typo? - Your driver name must be listed in your odbcconfig/odbcinst.ini file, the default driver name is EXAODBC and it's stored in here
- The error suggests the odbcinst.ini file is incorrectly configured or not present. By the way, what system are you using this package on? I was a little confused by the [Microsoft] part as the usual is [unixODBC]
Thanks!
from sqlalchemy-exasol.
Hi @nndo1991 , thanks for getting back to me.
- The utf-8 was a typo in my issue text and not in the actual code. I am running the code on a windows machine. I installed the
the ODBC driver from the official website of EXASOL but still the same error shows up.
I also installed the driver you referenced but I still get the same error.
Do you have any more pointers? Much appreciated!
from sqlalchemy-exasol.
Hi @Salma-Bouzid, we haven't tested this tool in Windows so far (whole team here is on Linux or Mac) but it should theoretically work.
Sqlalchemy uses pyodbc internally to establish connections to DBs, and everything in your error points to a driver setup issue. For that I would recommend some tests:
- Use the dockerfiles in this repo (which are unix-based) to build a Docker image and run the code from there
- Go one level deeper and try to connect to your DB straight from pyodbc (see step 5 of this guide)
- Search for pyodbc issues on their repo, I actually had a similar issue to yours and found similar information here
Thanks!
from sqlalchemy-exasol.
Closing this issue since it doesn't seem to be related to code in this repository
from sqlalchemy-exasol.
Related Issues (20)
- ✨ Add caching support for Exasol Dialects in respect to SQLA 1.4
- ✨ Add support for HASHTYPE, GEOMETRY and INTERVAL type
- ✨ Add list of un/supported SQLAlchemy features to documentation
- 🔧 Rework Integration Test Setup
- 🔧 Update Integration Test Docker Environment to 1.5.0
- 🐞 Difficult qmarks roundtrip tests fails
- 📦 Update SqlAlchemy package to version >=1.4 < 2.0.0
- Loosen version requirements on "packaging" HOT 1
- 🐞 After calling get_lastrowid through an insert, we see commit in the database. HOT 5
- 🐞 Prepared statements send the wrong types as parameters to the server HOT 1
- 🐞 Various SQLA compliance tests are failing for the websocket based dialect
- 🔧 Make pyodbc an optional dependency (feature) through setuptools extras HOT 3
- problem with Exasol driver's WebSocket connection cleanup process HOT 9
- 🔧 Add in code deprecation warnings for `[pyodbc, turbodbc]`
- 🔧 Remove `turbodbc` support
- 🔧 Remove `pyodbc` support
- 🔧 Remove tests/testing against Exasol 7.0.x
- ✨ Add support for testing of Exasol 8.x
- Support SQLAlchemy 2 HOT 3
- ✨ Make websocket types PEP-249 compliant HOT 5
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 sqlalchemy-exasol.