i am dealing with sql server database, where i have a table named 'table1' containing 1 column and 1 row exp_num 0 I am trying to update the 0 value exp_num column to +1 and also return old ex...

I am currently working on a python (3.8) project on my 2021 MacBook Pro with Apple Silicon. Ultimately, the goal is to build a ML model on data I read from an Azure SQL DB using Apple's Tensorflow ...

I'm currently trying to connect to a SQL Server (that I don't have visibility into, but have credentials for) using PyODBC. The code that I have works on my Windows desktop, but does not work when ...

I'm trying to install pyodbc for python 3.9.2 (32-bit), however I keep getting the error: C:\Users\ICAPP02\AppData\Local\Temp\pip-install-0c78okb8\pyodbc_d782ffa5512448c49f83e214e7ec4434\src\pyodbc...

I was looking for ways to speed up pushing a dataframe to sql server and stumbled upon an approach here. This approach blew me away in terms of speed. Using normal to_sql took almost 2 hours and th...

I'm using (executemany) function from pyodbc to populate data into an mssql database. This is my code: def populate_database(conn): tuples = [ ('2020-04-13 00:50:42', 'AirShoppingRQ', 'ALEY', '2...

Can the cursor.execute call below execute multiple SQL queries in one go? cursor.execute("use testdb;CREATE USER MyLogin") I don't have python setup yet but want to know if above form is...

I am trying to connect to my database on MS SQL Server 2016 using pyodbc via the below python script from my laptop (on Windows 10) and planning to have the code deployed in a Linux RHEL 6.4 server...

I'm stuck and can't figure out a workable way to connect asynchronously to an Azure SQL database using Python. I've tried asyncio, pyodbc and asyncpg to no avail. I think this is close... import as...

I am trying to run an Stored Proc in SQL Server (Synapse) using pyodbc.This SP merely performs INSERT operation into a table. sql =""" EXEC my_sp (?,?,?)""" values = (...

I have installed: Ubuntu (18.04) Python (3.6.8) msodbcsql17 (Microsoft ODBC Driver 17 for SQL Server) SQLAlchemy (1.3.5) Pandas (0.24.2) and I want to create just a proof of concept using SQLAl...

I'm trying to push a Flask app on Heroku which uses an Azure SQL database with pyodbc and ODBC Driver 17 for SQL Server. I followed the instructions from Heroku buildpack: odbc and created the foll...

def insert(self): conn = pyodbc.connect( 'Driver={SQL Server};' 'Server=DESKTOP-S0VG212\SQLEXPRESS;' 'Database=MovieGuide;' 'Trusted_Connection=yes;' ) cursor = conn.cursor() Error occurs ...

I have gone through every possible solution on the internet, but I'm unable to make pyobdc get the drivers on heroku. The steps I have used to create the app are as follows: heroku create heroku ...

I'm looking to create a temp table and insert a some data into it. I have used pyodbc extensively to pull data but I am not familiar with writing data to SQL from a python environment. I am doing t...

I am using Python 3.6, pyodbc, and connect to SQL Server. I am trying make connection to a database, then creating a query with parameters. Here is the code: import sys import pyodbc # connecti...

I am trying to install pyodbc with pip on macOS(12.3.1), but that didn't work. In error log, Message says "fatal error: 'sql.h' file not found". Some people are helped by the command brew...

I'am trying to import pyodbc library into google colab, but i'am getting this error. Just in case, I have Anaconda installed in my notebook, and I never had problem with pyodbc in there. Can you he...

I am trying to create a database using pyodbc, however, I cannot find it seems to be paradox as the pyodbc needs to connect to a database first, and the new database is created within the linked on...

I'm trying to build a custom docker container using the RHEL 8 UBI. As part of this I want to install the MSSQL 17 ODBC driver. I've followed the steps outlined in Microsofts Documentation here: ht...

To connect to Azure SQL Database using MFA (which is in SSMS as "Active Directory - Universal") Microsoft recommends and currently only has a tutorial on connecting with C# using Microsoft.Identity...

I'm using this code to sync my db with the clients: import pyodbc SYNC_FETCH_ARRAY_SIZE=25000 # define connection + cursor connection = pyodbc.connect() cursor = connection.cursor() query ...

I'm new to the linux world and I want to query a Microsoft SQL Server from Python. I used it on Windows and it was perfectly fine but in Linux it's quite painful. After some hours, I finally succe...

My question is somewhat the same as Python list of String to SQL IN parameter but I have a list of integers. The python code I use is: ids = [1000032, 1000048] sql = 'SELECT CompNo, CompName, Comp...

I normally use Postgres for my database needs with Django but I recently started at a company which use MSSQL on a Windows environment. Long story short I had to rewrite the database properties in ...