git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

pyodbc -> MS-SQL Server Named Instance ?


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