pyodbc -> MS-SQL Server Named Instance ?
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',
Traceback (most recent call last):
? File "<stdin>", line 6, in <module>
pyodbc.Error: ('28000', " [Microsoft][ODBC Driver 13 for SQL
Server][SQL Server]Login failed for user '*******'. (18456)
Highland Park Neighborhood Association
Adam Tauno Williams, Board Chair
Grand Rapids, MI.