Python Channel

When I execute the following code: for acc_row in cursor.execute('select * from tabela1'): … Read more Use Update In A Loop

I am connecting to an MS SQL Server db from Python in Linux. I am connecting via pyodbc using the … Read more Freetds Translating Ms Sql Money Type To Python Float, Not Decimal

When I try to connect to MS SQL, I got this error: > pyodbc.Error: ('08001', '[08001… Read more Python - Can't Connect To Ms Sql

I have a PostgreSQL running on localhost. I have psqlODBC Driver installed. Now when I try to conne… Read more Connecting To Postgresql Using Pyodbc

Ok so I have a script that connects to a mssql db and i need to run as a service which I have alrea… Read more Failed To Login As 'domain\computername' Pyodbc With Py2exe

The following works: import pyodbc pyodbc.connect('DRIVER={FreeTDS};Server=my.db.server;Databas… Read more Sqlalchemy Equivalent Of Pyodbc Connect String Using Freetds

I am using Python 2.7 on Windows XP. I have a simple python script on a schedule that uses pyodbc t… Read more Pyodbc Cursor.fetchall() Causes Python To Crash (segfault)

Is it possible to specify where pyodbc looks for the SQL driver? I have a python application which… Read more Pyodbc: Specify Location Of Driver In Windows

Executing the cmd as c:\>pip install pyodbc 'pyodbc.cp36-win32.pyd' file will be creat… Read more Importing Pyodbc Results As Internal Server Error In Apache Http Server

In ubuntu 19.04 when working with Python3 in an anaconda environment with pyodbc 4.0.26 installed I… Read more How To Fix 'can't Open Libmsodbcsql-17.3.so.1.1'

for _item in file_list: for col in cursor.execute('select column1,column2 from tbl'): … Read more Function Sequence Error (0) (sqlfetch) - Sql, Pyodbc

I am trying to execute SQL query within Access database using PYODBC and I get following error: p… Read more Too Few Parameters Error, While No Parameters Placeholders Used

I did successfully connected MySQL database with pyodbc, and it works well with ascii encoded data,… Read more Pyodbc Doesn't Correctly Deal With Unicode Data

I am trying to query MSSQL server 2012 using Python as my scripting language on a raspberry Pi3. I … Read more Querying Mssql Server 2012 From A Raspberry Pi 3 Using Python, Freetds And Pyodbc

I can currently connect to my SQL Server and query any database I want to directly. The problem is … Read more Connect To Linked Server Via Sql Server Pyodbc Connection?

I've had a look around SO and couldn't find this particular issue. So I have an ext config.… Read more Mixing Strings And Input Variable In Sql Connection String Using Pyodbc Library - Python

I am trying to call a stored procedure that creates a Database from pyodbc The Following is a minim… Read more Not Able To Create Database Using Stored Procedure Pyodbc Sql Server

I am trying to write a program in Python3 that will run a query on a table in Microsoft SQL and put… Read more Querying From Microsoft Sql To A Pandas Dataframe

I've checked stackoverflow a lot in the past and have always been able to find what I've be… Read more Inserting Values Into A Access 2003 Database From A Python Application Using Pyodbc

I have a Python program that connects to an MSSQL database using an ODBC connection. The Python lib… Read more How To Get Entire Varchar(max) Column With Python Pypyodbc