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
0 answers

pypyodbc "Login timeout expired" error on linux, same code working on windows machine

I have the below pypyodbc code running on my windows computer connecting to a windows server with a SQL database. When I use the exact same code on a linux machine in the same network I receive a pypyodbc.OperationalError: ('HYT00', '[HYT00]…
benschbob91
  • 155
  • 12
0
votes
0 answers

Unable to import pypyodbc in pyenv

I made a python script that goes throught a sql serve gets presciption records then after cleaning up the data I query it based on two parameters, all of this works by itself but now I wanted to make this into a application that others can interact.…
ZANDAR 2610
  • 1
  • 3
0
votes
0 answers

Connecting pyodbc to obscure proprietary ODBC connection that seems to use drivers from the 90s?

We're trying to use pyodbc to connect to an ODBC connection that's correctly configured through Win10's OBDBC Data Source Administrator (32-bit), but the driver is "SPAN Open ODBC", a string we ironically can't find anywhere on the internet. pyodbc…
for_all_intensive_purposes
  • 906
  • 10
  • 16
0
votes
2 answers

python how to write an update sql query?

I am trying to write an update query but I could not manage the string. My connections is ok. My query is like this: str='hello' cursor.execute('UPDATE users SET message = '+str+' WHERE UserId=13') This is giving me error: undefined column name…
aoiTenshi
  • 547
  • 1
  • 6
  • 20
0
votes
1 answer

Why does .decode() result in NaN values for byte strings that resulted from the pd.read_sql_query function?

I have a MS SQL database that I want to query with Python. I use the following snippet: cnxn = pypyodbc.connect("Driver={SQL Server Native Client 11.0};" "Server=xxxx;" "Database=xxxx;" …
sander
  • 1,340
  • 1
  • 10
  • 20
0
votes
1 answer

ValueError when reading dates from hfsql database using ODBC

With some struggles I connected to a hfsql server using ODBC. I've tried both pypyodbc and pyodbc. My goal is to get some insights in the data (and visualize some aspects). For some planning visualization I need to read out some of the data, which…
WvdL1995
  • 29
  • 5
0
votes
0 answers

Transfer resultset of python cx_Oracle to SQL Server table?

I am new to Python and I have asked to transfer the data from the Oracle table to SQL Server table using the python script. I have used cx_Oracle and fetched the data from Oracle this data is like tuple row and I have converted it as a list and then…
jslover2020
  • 1
  • 2
0
votes
2 answers

Python to MS SQL Error: Error when connecting to SQL using sqlalchemy.create_engine() using pypyodbc

Scenario: I am trying to Convert the SQL output directly to Table using dataframe.to_sql, so for that i am using sqlalchemy.create_engine() and its throwing error when trying to createngine() sqlchemyparams=…
Rahul
  • 21
  • 7
0
votes
1 answer

Docker ubuntu 20 unable to install msodbcsql17 or 13 SQL SERVer odbc Driver 13 or 17

unfortunately I'm a bit desperate. I have created a dockerimage and am running everything with docker-compose. If i run docker-compose up i get this error: | django.core.exceptions.ImproperlyConfigured: 'mssql' isn't an available database backend or…
Paddymaster
  • 70
  • 1
  • 10
0
votes
0 answers

Issue creating CSV from Access database

I have a database in MS Access. I am trying to export one column from one table to a CSV file, with Python using pypyodbc. From the CSV file obtained, there are no commas in numbers greater than 1. Any idea to solve? Screen from MS Access: MS Access…
LucaSful
  • 1
0
votes
0 answers

pypyodbc query only working with numerical fields

Good day everyone, I have a student who has chosen to create a program that links python to an access database for his coursework. He has the code for the connections etc and SOME queries work as intended. The Database is one about films so the…
iDadio
  • 1
0
votes
0 answers

How to check if a specific string exists in a specific column, in a specific SQL DB table using pyodbc?

I am trying to create a Login Window (tkinter), and I am trying to get the inputs in a SQL DataBase Table. I am getting an error at this code, I am also trying to see wether the inputs are already in the table or no: def check (username,…
cybiroot
  • 1
  • 2
0
votes
2 answers

Issues with IF statements and Pypyodbc

I am brand new to Python and know very little. I have connected my MS-Access file to my python using Pypyodbc. I am attempting to query with it using a user input however, I need it to be able to change based on the input of the user rather than…
NewtoPython08
  • 1
  • 1
0
votes
0 answers

unable to use pyodbc on mac

i am trying to use pyodbc to connect to azure sql from python and i am getting this error saying pyodbc module not found although i have it installed as you can see in snippet below: (apienv) (base) manishshukla@Manishs-MacBook-Pro scriptureApi %…
Manish Shukla
  • 313
  • 1
  • 3
  • 17
0
votes
0 answers

pypyodbc get relationship between MS Access Tables

When reading an MS Access db with several tables with relationships between them, can pypyodbc read the relationship between the tables?
Pete
  • 75
  • 1
  • 2
  • 13
1 2 3
…
18 19