Top "Pymssql" questions

A discontinued interface for Python that provided a standard Python DB-API interface to Microsoft SQL Server.

Adaptive server connection failed (DB-Lib error message 20002, severity 9)

I'm sure this issue has been raised an uncountable number of times before but perhaps, someone could still help me. …

python azure-sql-database pymssql
python and pymssql

I'm new to python. I'm trying to query a MSSQL database. import pymssql conn = pymssql.connect(host='hostname', user='username', …

python sql sql-server pymssql
Using pymssql to insert datetime object into SQL Server

How do I insert a datatime object using pymssql? I know that the SQL Server table is expecting a datetime …

python sql-server windows pymssql
ImportError: No module named pymssql error when run from batch file

I have a simple .py file that queries a DB server with pymssql that works as required. I am trying …

python batch-file scheduled-tasks pymssql
How to install pymssql module in Python 3.6?

I have been through a couple of documentations involving FreeTDS, Wheel, git and github but nothing was working on my …

python-3.x python-3.6 pymssql
Convert or strip out "illegal" Unicode characters

I've got a database in MSSQL that I'm porting to SQLite/Django. I'm using pymssql to connect to the database …

python unicode pymssql
PYmssql python connection string

I have downloaded Pymssql to connect to the sqlserver db but the connection string is throwing error-pymssql.connect(pymssql.c.:7990) …

python pymssql
Insert Data to SQL Server Table using pymssql

I am trying to write the data frame into the SQL Server Table. My code: conn = pymssql.connect(host="Dev02", …

python sql-server pandas pymssql
Error Installing pymssql

I'm fairly new to Python development but very quickly I've run into a roadblock and I'm not sure how to …

python msbuild pymssql
get column names from query result using pymssql

Is there any way to get the column names from the pymssql results? If i specify as_dict=True I …

python database pymssql