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

pypyodbc help to find tutorials for begining

The question may sound stupid but can someone please provide me with pypyodbc with postgresql....? I have been searching it in internet forever and havenot found anything* literally anything.
user3270101
  • 11
  • 1
  • 1
0
votes
0 answers

exception when using ipy64 with pypyodbc

I'm trying to create a database with MSAccess using pypyodbc on Ironpython. I have this working perfectly fine on my old machine, but I must migrate to a new machine. However on the new machine I get an exception trying to run the same script. Using…
John
  • 787
  • 4
  • 11
  • 28
0
votes
1 answer

How to connect to access (.mdb) database with pyodbc using latin-1 filename

I use this code to connect to my access (.mdb) database: # -*- coding: latin-1 -*- fileMDB = 'C:\\Python27\\OptimisateurLievre\\final\\Archives_PrevisionsESP_Août_2013.mdb' param = "Driver={Microsoft Access Driver (*.mdb)};DBQ={%s};PWD={pw}" %…
user2661075
  • 11
  • 4
-1
votes
1 answer

getting error while running the following python script to get a table from mssql server

im getting error while running this python script import pypyodbc as odbc import pandas as pd # uid = ; # pwd = ; # Set up a connection to the database DRIVER_NAME = 'SQL SERVER' SERVER_NAME = 'some_server_name' DATABASE_NAME =…
dona
  • 3
  • 2
-1
votes
1 answer

"SAWarning: No driver name specified; this is expected by PyODBC when using DSN engine = sa.create_engine(SQLALCHEMY_DATABASE_URL)"

Having issues connecting to my sql-server using pyodbc after several checks. from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker import pyodbc SQLALCHEMY_DATABASE_URL =…
Seun
  • 1
  • 2
-1
votes
1 answer

'pyodbc.Cursor ' object has no attribute 'index'

whenever i tried to show the sql table FROM INFORMATION_SCHEMA.TABLES Name list in a qtableView by using pandasModel class in Pyqt5 Application, i got this error 'pyodbc.Cursor ' object has no attribute 'index'. i am using mssql server 2019. i…
Dhurjati Riyan
  • 116
  • 1
  • 3
  • 13
-1
votes
1 answer

append an extra column to INSERTs from a CSV file

I need to append a column/value to the below insert. The value is the same for every row.I can append the column name to the cols tuple, but cannot seem to append the value to the data.I am reading from hundreds of text files of varying format, and…
hecramsey
  • 1
  • 2
-1
votes
1 answer

writing data frames to a sql table

I'm reading from one database and outputting certain columns to another database. I use a data frame to store the data and then iterate through the frame to output the column i'm interested in.: for i in range(0,len(myframe.index)): …
C0ppert0p
  • 634
  • 2
  • 7
  • 23
-1
votes
1 answer

name 'connection' is not defined

I'm trying to close the ODBC connection and I'm not sure about the best way to implement this. My program runs but I'm wanting to close the connection properly with connection.close(). Here is my original: import pypyodbc def queryfirst(): …
Prox
  • 699
  • 5
  • 11
  • 33
-1
votes
1 answer

MSSQL Server 2012 and pypyodbc

I am running an application on linux machine and database mssql server. We use pypyodbc to connect to the db server with ip and port. conn_str = "DRIVER=FreeTDS;SERVER=192.168.0.1;PORT=1433;DATABASE=xxx;UID=sa;PWD=xxx;TDS_Version=8.0" …
Karesh A
  • 1,731
  • 3
  • 22
  • 47
-1
votes
3 answers

Python SQL query using variables

#Delete suspense window class dWindow(QtGui.QMainWindow, Ui_dWindow): def __init__(self, parent = None): QtGui.QMainWindow.__init__(self, parent) self.setupUi(self) for row in cursor.execute("SELECT FIRSTNAME FROM…
ricketyCode
  • 11
  • 1
  • 4
-1
votes
2 answers

Insert Data Into A Table Using The Same Foreign Key Value

I'm using SQL Server, Python, pypyodbc. The tables I have are: tbl_User: id, owner tbl_UserPhone: id, number, user_id user_id is the primary key of User and the foreign key of UserPhone. I'm trying to insert 2 different phones to the same user_id…
Shani Gamrian
  • 345
  • 1
  • 4
  • 18
-1
votes
1 answer

python pypyodbc writing to dBase not working

Have a terrible time trying to get this working. Spent way too many hours doing searches only to come up with the same examples which are not helping. Made myself a GUI that starts a Thread to read the serial ports and parse some GPS data into NMEA…
Chef Flambe
  • 885
  • 2
  • 15
  • 35
-1
votes
1 answer

Inserting YahooFinance data into SQL database using Python

I am trying to insert data retrieved from YahooFinance into a SQL Server database, using Python's pypyodbc. I am using the code below: import pypyodbc import ystockquote conn = pypyodbc.connect('DRIVER={SQL…
Nanaki
  • 19
  • 5
1 2 3
…
18
19