Questions about pyodbc
Read more about pyodbc
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Windows docker container with python and c++ build tools OR connect python with SQL Server without c++ build tools
I currently use pyodbc to push and pull from a Microsoft SQL Server. Pyodbc needs the Visual Studio C++ build tools to work.
I am putting this project into a docker container as a flask app along with...
ceej pie
Votes: 0
Answers: 0
SQL update keeps spitting syntax errors when my code seems properly formatted
I have this piece of code that tries to update the date column with ID = m. m is an integer as it's supposed to be and for date I have tried both a string and a datetime.date.
sql = '''UPDATE DaByDa...
Blazing Blast
Votes: 0
Answers: 2
Pyodbc 'Object reference not set to an instance of an object.'. (111213) with bulk insert
i have been working with bulk inserts on our Azure SQL Pool(Formerly SQL DW) with this code:
def save_sql_bulk(self, table_name, schema, file_path):
logging.info(f"Starting proccess to sa...
frammnm
Votes: 0
Answers: 1
Unable to establish connection to sql-server using pyodbc on Windows 10
import pyodbc as sql
import pandas as pd
source_db_config = {
'Trusted_Connection': 'yes',
'driver': '{SQL Server}',
'server': '.',
'database': 'AdventureWorksDW2017',
'autocommit...
feel ownmind
Votes: 0
Answers: 1