Pyodbc creator function ignored in create_engine (mssql)

[Peter Lai]

example:

import pyodbc

from sqlalchemy import create_engine

def creator():
    config = {
        'driver': 'ODBC Driver 13 for SQL Server',
        'host': 'localhost',
        'port': 1433,
        'user': 'me',
        'pw': 'mypw',
        'dbname': 'mydb'
    }
   
    return pyodbc.connect(
        "DRIVER={{{driver}}};SERVER={host},{port};DATABASE={dbname};UID={user};PWD={pw}".format(
            driver=config['driver'],
            host=config['host'],
            port=config.get('port',1433),
            dbname=config['dbname'],
            user=config['user'],
            pw=config['pw']
        )
    )

# works
odbc_conn = creator()

# fails
e = create_engine('mssql://', creator=creator)

/usr/lib/python3.6/site-packages/sqlalchemy/connectors/pyodbc.py:79: SAWarning: No driver name specified; this is expected by PyODBC when using DSN-less connections

  "No driver name specified; "

This is on SqlAlchemy 1.3.17

[Mike Bayer]

that's only a warning, it's not a failure.

We will look into the warning message, however if you e.connect(), it works fine.

--

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 sqlalchemy+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/d3691dac-431b-4ed1-8670-59b8b959f81f%40googlegroups.com.