On Tue, 2019-07-02 at 09:41 -0400, Adam Tauno Williams wrote: > On Tue, 2019-07-02 at 07:36 +0200, Frank Millman wrote: > > On 2019-07-01 10:13 PM, Adam Tauno Williams wrote: > > > I am trying to connect to a Named Instance on an MS-SQL server > > > using pyODBC.
It appears that the instance location service doesn't work. Digging out the instance->power assignment I can change the error message and create an authentication failed even in the Event Log! It is sorta progress. :( >>> db = pyodbc.connect( ... driver='ODBC Driver 13 for SQL Server', ... server=r'sql.example.com,51994', ... database='dbname', ... user='*******', ... password='*******', ) Traceback (most recent call last): File "<stdin>", line 6, in <module> pyodbc.Error: ('28000', "[28000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user '*******'. (18456) (SQLDriverConnect)") -- Highland Park Neighborhood Association Adam Tauno Williams, Board Chair Grand Rapids, MI. -- https://mail.python.org/mailman/listinfo/python-list