pyodbc -> MS-SQL Server Named Instance ?

[Adam Tauno Williams]

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.