sqlacodegen mssql+pyodbc://user:password@host/database
On Monday, November 9, 2020 at 11:03:03 PM UTC-5 Mike Bayer wrote:
> this has to do with how you are formatting your URL, and it is being seen
> as a hostname and not a DSN name. can't provide any more help without
> seeing how you are formatting this URL as well as what is the actual method
> you are trying to use to connect (DSN or hostname).
>
>
>
>
> On Mon, Nov 9, 2020, at 6:44 PM, Larry Martell wrote:
>
> 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
>
> <https://groups.google.com/d/msgid/sqlalchemy/45a0c405-f6c9-4778-8e5c-fd179f633f45n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
--
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/80a46434-b025-4cbe-89a7-886f8c8869fcn%40googlegroups.com.
