Skip to content Skip to sidebar Skip to footer
Showing posts with the label Pymssql

Strings Used In Query Always Sent With Nvarchar Syntax, Even If The Underlying Column Is Not Unicode

I'm noticing some odd behavior in the SQL generated for queries against string fields in MS SQL… Read more Strings Used In Query Always Sent With Nvarchar Syntax, Even If The Underlying Column Is Not Unicode

Tsql Login Failed But Management Studio Can Connect

I'm trying to connect to a MS SQL Server instance using tsql (to troubleshoot not being able to… Read more Tsql Login Failed But Management Studio Can Connect

Sqlalchemy Connects To Sqlserver Using Windows Authenticaton With Pymssql Driver

I can use pymssql to connect to SQLServer using Windows Authentication: conn = pymssql.connect(host… Read more Sqlalchemy Connects To Sqlserver Using Windows Authenticaton With Pymssql Driver

Pymssql: How To Use Windows Authentication When Running On A Non-windows Box

Is there a way for python to connect to MS SQL Server using Windows Authentication, even when not r… Read more Pymssql: How To Use Windows Authentication When Running On A Non-windows Box

SQL Server Log In Failing From Java DriverManager.getConnection(), Working From Python With Pymssql.connect()

I'm trying to use DriverManager.getConnection() to connect to a SQL Server db from a Java appli… Read more SQL Server Log In Failing From Java DriverManager.getConnection(), Working From Python With Pymssql.connect()