On 2019-07-02 3:41 PM, 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.
This is what I use -
conn = pyodbc.connect(
driver='sql server',
server=r'localhost\sqlexpress',
database=self.database,
user=self.user,
password=self.pwd,
trusted_connection=True)
SQL Server is running on the same host as my python program, so it
may be a simpler setup than yours.
What ODBC driver are you using?
[...]
I did reply to this yesterday but for some reason it did not appear. For
the record, here it is again -
I am not using an ODBC driver at all. My connection string 'just works'.
This is the version of Sql Server I am using -
C:\Users\User>sqlcmd
1> select @@version
2> go
Microsoft SQL Server 2017 (RTM-GDR) (KB4494351) - 14.0.2014.14 (X64)
Apr 5 2019 09:18:51
Copyright (C) 2017 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build
17134: )
Frank
--
https://mail.python.org/mailman/listinfo/python-list
