Stack Overflow
Stack Overflow

Questions tagged [pymssql]

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

Pymssql was an interface for Python that provided a standard Python DB-API (as defined by PEP 249) interface to Microsoft SQL server. It was discontinued in November 2019.

Related tags:

542 questions
56
votes
4 answers

trying to install pymssql on ubuntu 12.04 using pip

I am trying to install pymssql on ubuntu 12.04 using pip. This is the error I am getting. Any help would be greatly appreciated as I am completely lost! Tried googling this but unfortunately to no avail... Downloading…
dreamwalker
  • 1,491
  • 3
  • 15
  • 21
41
votes
4 answers

MSSQL in python 2.7

Is there a module available for connection of MSSQL and python 2.7? I downloaded pymssql but it is for python 2.6. Is there any equivalent module for python 2.7? I am not aware of it if anyone can provide links. Important note: in the meantime…
Shashi
  • 2,001
  • 2
  • 20
  • 34
32
votes
7 answers

mac - pip install pymssql error

I use Mac (OS X 10.11.5). I want to install module pymssql for python. In Terminal.app, I input sudo -H pip install pymssql, pip install pymssql, sudo pip install pymssql . But error occur. The directory /Users/janghyunsoo/Library/Caches/pip/http…
장현수
  • 355
  • 1
  • 3
  • 8
16
votes
5 answers

pymssql windows authentication

The pymssql module used to support windows authentication. Now it seems it does not. Though in some places it still shows that it should work. I have been unable to find a definitive answer to this problem, nor a solution. Most relevant…
Inbar Rose
  • 35,719
  • 22
  • 80
  • 120
15
votes
4 answers

Cannot connect to SQL Server database using pymssql but can connect using underlying freetds tsql

I have no idea why I am getting this error and cannot find any solutions for it. I can connect to a SQL Server database using freetds tsql but I keep getting an error when connecting using pymssql.connect. The specific error…
chewynougat
  • 979
  • 2
  • 10
  • 19
14
votes
2 answers

How to install pymssql on MacOS Sierra

Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-build-J1I0ox/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))"…
binzabinza
  • 535
  • 5
  • 14
13
votes
6 answers

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', password='password', database='dbname') cursor = conn.cursor() sql = "select count(*) from T_Email with (nolock) where…
user2430259
13
votes
1 answer

Flask app with ArcGIS, Arcpy does not run

I have a script that gets a table from MSSQL database and then registers it with ArcGIS. It uses several other arcpy methods as well. I tried to combine it with Flask and developed an HTML interface where you can specify tables. The script runs on…
Efkan
  • 359
  • 2
  • 7
13
votes
3 answers

Unable to connect to SQL Server via pymssql

I am attempting to connect to SQL Server running on Windows XP system from a *nix system on a local server via pymssql. However, the connection fails as shown below db =…
Christopher
  • 4,946
  • 7
  • 27
  • 39
13
votes
1 answer

How do I use SQL parameters with python?

I am using python 2.7 and pymssql 1.9.908. In .net to query the database I would do something like this: using (SqlCommand com = new SqlCommand("select * from Customer where CustomerId = @CustomerId", connection)) { …
Jason Webb
  • 7,528
  • 9
  • 38
  • 49
12
votes
4 answers

How to install pymssql on windows with python 2.7?

It seems that there are no such binaries yet. There is an issue on googlecode: http://code.google.com/p/pymssql/issues/detail?id=12 but i cannot figure out what to do with those files provided.
Cubius
  • 1,154
  • 2
  • 11
  • 32
11
votes
3 answers

pymssql and Adaptive Server connection failed

When I try to connect into Azure database by Pymssql in python I face this error: pymssql.OperationalError: (20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (iprice-bi.database.windows.net:1433)\n') I connect to…
Moohebat
  • 395
  • 1
  • 5
  • 14
10
votes
3 answers

Pymssql Install Error

I'm trying to install FreeTDS using binaries from here, on Windows, but I can't figure out how to install binary files; a google search turned up nothing relevant. I'm installing so that the Python module Pymssql can be imported and used. I'm…
Fricative Melon
  • 293
  • 2
  • 12
10
votes
9 answers

How do you get output parameters from a stored procedure in Python?

I've googled around a bit, but maybe I didn't put the correct magik incantation into the search box. Does anyone know how to get output parameters from a stored procedure in Python? I'm using pymssql to call a stored procedure, and I'm not sure of…
projecktzero
  • 1,152
  • 1
  • 9
  • 11
9
votes
1 answer

How to execute an .sql file in pymssql

I'm trying to execute an sql file in python using pymssql, this file contains a BEGIN TRANSACTION, a COMMIT TRANSACTION and an END, and some safety nets before and after. I'm trying to open the file in memory and execute the content: file =…
fragk
  • 93
  • 1
  • 7
1
2 3
…
36 37