I am trying to use sqlacodegen on a mac to generate models from a MS SQL
db. I get this error when I run:
sqlacodegen mssql+pyodbc:xxx
pyodbc.InterfaceError: ('IM002', '[IM002] [unixODBC][Driver Manager]Data
source name not found and no default driver specified (0)
(SQLDriverConnect)')
I can successfully connect to the db using the same DSN:
$ python3.8Python 3.8.6 (v3.8.6:db455296be, Sep 23 2020, 13:31:39)
[Clang 6.0 (clang-600.0.57)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> from sqlalchemy import create_engine
>>> create_engine("mssql+pyodbc://xxx")
/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/sqlalchemy/connectors/pyodbc.py:80:
SAWarning: No driver name specified; this is expected by PyODBC when using
DSN-less connections
util.warn(
Engine(mssql+pyodbc://xxx)
>>>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/45a0c405-f6c9-4778-8e5c-fd179f633f45n%40googlegroups.com.
