A simple Python module to query the SQL Browser service for the port number of a SQL Server instance. The Linux implementation of Microsoft's "ODBC Driver xx for SQL Server" is (still) unable to resolve instance names, so Windows users can just do
importpyodbcserverspec=r'myserver\SQLEXPRESS'conn=pyodbc.connect('DRIVER=ODBC Driver 13 for SQL Server;SERVER={};...'.format(serverspec))but that won't work on Linux. This module lets us do
importpyodbcimportsqlserverportservername='myserver'serverspec='{0},{1}'.format(
servername,
sqlserverport.lookup(servername, 'SQLEXPRESS'))
conn=pyodbc.connect('DRIVER=ODBC Driver 13 for SQL Server;SERVER={};...'.format(serverspec))