Stack Overflow
Stack Overflow

Questions tagged [pypyodbc]

pypyodbc is a pure Python ODBC interface module. (Not to be confused with pyodbc, which performs many of the same functions but was written as an *extension module* in C++.)

pypyodbc is a pure Python interface module. It is very similar to , which performs many of the same functions but was written as an extension module in C++.

In addition to being a very good ODBC Library in its own right, pypyodbc is a useful alternative to pyodbc in situations where pyodbc encounters difficulties.

For more information, see

pypyodbc - A Pure Python ODBC Library

Installation is available from pip:

pip install pypyodbc

Or by downloading installation package. (Unzip, navigate to folder, and run:)

python setup.py install
285 questions
0
votes
1 answer

Pyodbc Calling a stored procedure with parameters

I've been trying to call this stored procedure with parameters to no avail. I think I've figured out the parameter part, but now I think I'm just plain calling the stored procedure wrong. I tried to document my different approaches as best possible…
SoSincere3
  • 117
  • 1
  • 10
0
votes
2 answers

Passing parameters to a saved query in MS Access

Ok, I tried every possible situation from SO, and none of it did the job. I have a problem calling a saved query which requires 4 parameters to be passed (talking about access database), and I have a simple code : params = () sql_saldo = "{CALL…
dev.ink
  • 380
  • 5
  • 21
0
votes
1 answer

What causes ODBC connection error 08001 ssl security error

I can access SSIS server and DB from SSMS on local desktop, getting results from select * from sysjobs. In trying to access the SSIS server and DB from python 3.7 64-bit, using connection string Driver={SQL Server}; Server=BSWHPACTIANDBD1;…
user1313358
  • 61
  • 1
  • 2
  • 6
0
votes
0 answers

Python3 pypyodbc SQL Server call stored procedure fails

The Python 3.8.1 code that I am working with makes several calls to stored procedures, gets results, does a simple select statement passing a string -- all successfully, using pypyodbc. My last call has me stumped as it simply fails to produce any…
Lou57
  • 21
  • 2
0
votes
0 answers

pypyodbc connection to Filemaker throws "list index out of range" error

Trying to connect a python script to our filemaker db. It was working with a previous copy of db but recently connecting to new version, it started throwing an error "list index out of range" when trying to grab a table from the DB. Using Python…
constdoc constdoc
  • 54
  • 7
0
votes
1 answer

In pypyodbc, How to query a table for its distinct values, truncate old table and append the distinct values to the empty table

I have a table that for whatever reason has some dupes after a process runs. Each row should be a distinct report. I'm trying to do this with a for look on the cursor object after doing the .fetchall method and it is working somewhat. But it only…
Ben Smith
  • 360
  • 4
  • 14
0
votes
1 answer

Pypyodbc TabError: inconsistent use of tabs and spaces in indentation

This is a common problem it seems on here but in my case I cant find an answer. Why is it saying inconsistent use of tabs and indentation here def exectute_SQL(): #This function executes SQL to pull counts from a table where it wasnt possible to…
Ben Smith
  • 360
  • 4
  • 14
0
votes
1 answer

Using executemany() with PYPYODBC

My project is currently using pypyodbc Python library to connect to DB2 database, my source is a MS SQL server and I need to read data from that and load the data to a DB2 table. The data volume is million rows and I am attempting to use the…
Devender Kumar
  • 1
  • 1
  • 4
0
votes
2 answers

Insert data in sql server with python

I want to insert data in the sql server from a raspberry pi with python. I tried with pypyodbc but it s not working properly. Can you guide me witch module to use. import pyodbc conn = pyodbc.connect( 'DRIVER={SQL Server…
Catalin
  • 15
  • 1
  • 6
0
votes
1 answer

Limit of 100k rows

I am querying a historical database and the result table should have around 144k rows but I am getting the result limited to 100k lines. I have already seem this problem using ODBC connection to the same DB but using a VBA .NET application. I tested…
Dariva
  • 330
  • 2
  • 13
0
votes
1 answer

PypyODBC with parameters: [ODBC Microsoft Access Driver] Too few parameters. Expected 3 (not a Date issue)

I'm setting up small RestFul API based on Flask to have an access to a DB. I've tackled GET and POST methods which are working great, but having issues with PUT. I've already swapped pyodbc to pypyodbc since it actually have 'update' methods. I'm…
Kirill Gorshkoff
  • 1
  • 2
0
votes
1 answer

python use query_1 result in query_2 where condition as both the query will run in different sql server

python use query_1 result in query_2 where condition as both the query will run in different sql server cnxn = pyodbc.connect(driver = '{SQL Server}', host = 'server1', database = 'db1', user = '', password = '', Trusted_Connection = 'yes') cursor =…
Surya Pranes Vasudevan
  • 1
  • 1
  • 3
0
votes
1 answer

Pypyodbc query returning incorrect data

Hi there so bit of an odd one, the sql query im running is SELECT [idPerson] FROM tblPersons WHERE [Email] LIKE 'Joe.Pike%' If i run this in the server i get my correct personID, however when i run it in my code i get a random personID that doesn't…
joe___pike
  • 11
  • 6
0
votes
1 answer

Incorrect syntax near Go with Pypyodbc

I am using the pypyodbc library to establish a connection to a SQL Server 2008 R2 database and every time I try to execute a .sql file I encounter the following error: pypyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server…
abautista
  • 2,410
  • 5
  • 41
  • 72
0
votes
0 answers

How to make many querys with cursor to SQL server with pypyodbc

Im pretty new to sql, so bear with me.. I have a database with 22 tables, all connected with a primarykey (product number) I need to get all columns from all tables that match one primary key. Today i use a query ala this: query = """ select *…
Louvre
  • 169
  • 1
  • 15
1 2 3
…
18 19