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:

621 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,693
  • 3
  • 18
  • 23
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,137
  • 3
  • 22
  • 37
38
votes
3 answers

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
  • 634
  • 5
  • 9
33
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…
장현수
  • 373
  • 1
  • 3
  • 9
18
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
  • 41,843
  • 24
  • 85
  • 131
17
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
  • 564
  • 1
  • 5
  • 14
16
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
  • 1,099
  • 2
  • 11
  • 19
15
votes
3 answers

How do I set the schema in SQLAlchemy for MSSQL?

I currently do this: #!/usr/bin/env python # 3rd party modules from sqlalchemy import create_engine # requires pymssql # local modules from config import cfg connection_string = 'mssql+pymssql://{user}:{password}@{host}:{port}/{db}' engine =…
Martin Thoma
  • 124,992
  • 159
  • 614
  • 958
15
votes
4 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
  • 455
  • 1
  • 6
  • 15
14
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,938
  • 9
  • 40
  • 49
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
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
  • 5,806
  • 7
  • 31
  • 41
13
votes
10 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,192
  • 1
  • 9
  • 11
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,294
  • 2
  • 15
  • 33
11
votes
4 answers

ERROR: Could not build wheels for pymssql which use PEP 517 and cannot be installed directly

I'm trying to install pymssql from pip on Windows. Problem is, I keep getting the following error: ERROR: Failed building wheel for pymssql Failed to build pymssql ERROR: Could not build wheels for pymssql which use PEP 517 and cannot be installed…
Jacob Kapitein
  • 245
  • 1
  • 4
  • 14
1
2 3
…
41 42