I have an issue with installing pymsql, any of you had a similar case? I've found the similar issue to my for M1 user Link Also I've try: Upgrade pip with: python -m pip install --upgrade pip Upgra...

I`m using MacBook with M1 chip and seems like multiple things arent optimised for it. pyodbc didnt work for me, so I wanted to use pymssql. Though, I encountered this issue when I tried to run pip ...

I am trying to write the data frame into the SQL Server Table. My code: conn = pymssql.connect(host="Dev02", database="DEVDb") cur = conn.cursor() query = "INSERT INTO dbo.SCORE_TABLE VALUES (%s, ...

I'm sure this issue has been raised an uncountable number of times before but perhaps, someone could still help me. I am using pymssql v2.1.3 with Python 2.7.12 and the code that I used several tim...

I'm attempting to connect to a SQL Server instance from a Windows box using pymssql (version 2.0.0b1-dev-20111019 with Python 2.7.1). I've tried the most basic approach from the console: import pym...

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...

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 interfac...

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 (ipri...

Does anyone know a way to connect to a SQL Server database from Python without installing a driver like ODBC? I need to do that on a customer server. I already established a connection from Python ...

I want to receive rows as dictionaries in pymssql. in python-idle i ran: >>> conn = pymssql.connect(host='192.168.1.3', user='majid', password='123456789', database='GeneralTrafficMonitor...

I am trying to use Pandas and Sql Alchemy. This is basically what I am trying to do. If I drop the table, it will create it but I want it to append and not have to do table renaming. I have tried u...

I am using PyMSSQL to connect to a database. However, if I enter the incorrect details or there is some other problem, PyMSSQL throws an exception. However, I cannot work out how to catch the excep...

I'm running Python 2.7.2 on OS 10.8.5 Trying to use pymssql, but I get the following error: File "time_reporting.py", line 32, in <module> import pymssql File "/Users/xx/.virtualenvs/or...

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 pym...

I am trying to connect to a Microsoft sql server database using pyodbc. I keep getting the error Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Ser...

I have python application that shoud be launched as windows executable. I'm using py2exe and pymssql 1.9.908. I used next build script to generate application: from distutils.core import setup im...

What are the steps required to configure pymssql with SSL support on Ubuntu so I can connect to a SQL Server instance that requires an encrypted connection (e.g., Azure)?

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')...

Trying to list the names of the databases on a remote MS SQL server using Python (Just like the Object Explorer in MS SQL Server Management Studio). Current solution: The required query is SELECT...

I am connecting to a SQL Server database using SQLAlchemy (with the pymssql driver). import sqlalchemy conn_string = f'mssql+pymssql://{uid}:{pwd}@{instance}/?database={db};charset=utf8' sql = 'SE...

I have been through a couple of documentations involving FreeTDS, Wheel, git and github but nothing was working on my Windows 10 PC with Python 3.6 but I need to install it. I'm working on a projec...

I had been working with pyodbcfor database connection in windows envirnment and it is working fine but now I want to switch to pymssql so that it is easier to be deployed to Linux machine as well. ...

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:...

I'm fairly new to Python development but very quickly I've run into a roadblock and I'm not sure how to resolve it. I am using Python 3.6 and VS Code as an IDE, but I also have VS 2015 Express and ...

I am using SQL server database. I've noticed that when executing the code below, I get a connection to the database left over in 'sleeping' state with an 'AWAITING COMMAND' status. engine = creat...