Get server name (SQL Server Host) through SQL Alchemy session or engine

Question

Where is the server name found in the SQL Alchemy session or engine?

I prefer not parsing the query property.

e = connManager.get_engine()

e.engine.url

mssql+pyodbc:///?odbc_connect=DRIVER={SQL Server Native Client 11.0};SERVER=myhost;DATABASE=mydatabase;TRUSTED_CONNECTION=Yes
database:''
drivername:'mssql+pyodbc'
host:None
password:None
port:None
query:{'odbc_connect': 'DRIVER={SQL Server ...CTION=Yes'}
'odbc_connect':'DRIVER={SQL Server Native Client 11.0};SERVER=myHost;DATABASE=mydatabase;TRUSTED_CONNECTION=Yes'
__len__:1
username:None

Gord Thompson · Accepted Answer · 2019-12-13 22:30:25Z

1

I don't think the server name alone is stored in the Engine object anywhere, but you could always ask pyodbc to interrogate the driver:

import pyodbc

# ...

cnxn = engine.raw_connection()
server_name = cnxn.getinfo(pyodbc.SQL_SERVER_NAME)
print(server_name)  # GORD-HP\SQLEXPRESS

answered Dec 13, 2019 at 22:30

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dirtyw0lf Over a year ago

Which pyodbc property gets the schema name?

Collectives™ on Stack Overflow

Get server name (SQL Server Host) through SQL Alchemy session or engine

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related