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: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send())

My python script reads through around half of the dataset (around 5000 rows out of 10000) and all of a sudden produces this error midway: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()) I'm using pypyodbc to connect to the…
90abyss
  • 7,037
  • 19
  • 63
  • 94
0
votes
1 answer

Python: Convert TupleRow to a Datetime object

I'm querying into a SQL server to fetch a DATETIME value. Now I want to insert this value into another table. This is my script: cursor2.execute(query1) items = cursor2.fetchall() for item in items: cursor1.execute(query2, [item[0]]) c_date…
90abyss
  • 7,037
  • 19
  • 63
  • 94
0
votes
1 answer

Insert csv file into SQL Server database: error with listdir?

I know it's bad to throw code here and ask for help to trouble shoot. This problem seems a little over my head. The code is supposed to loop through all the files and sub folders. I don't think there is any log error here. The problem is I ran into…
frank j
  • 131
  • 1
  • 1
  • 4
0
votes
2 answers

MariaDB, pypyodbc, "Unknown prepared statement handler" executing "SELECT" query on table loaded with "LOAD DATA LOCAL INFILE."

Python 3.4.3, MariaDB 10.0.21, MariaDB ODBC Connector 1.0.0, pypyodbc 1.3.3, all 64-bit on 64-bit Windows 7. I've got a python script that's supposed to create a table, populate it with data from a fixed-width file, and then run a SELECT statement…
Logan Jones
  • 324
  • 1
  • 3
  • 10
0
votes
0 answers

I need to remove o rnot include the ',' in my result

My problem is when I query my database like so upperBound.extend(cursor.execute(queryUpper, ['SN00010', '2015-05-07 22:16:00.810']).fetchall()) Where queryUpper grabs the upper bounds column from the database and ['SN00010', '2015-05-07…
Vermonster
  • 68
  • 10
0
votes
1 answer

connect to Oracle11g DB from pypyodbc

Am relatively beginner level python dev here. I am just not able to connect to Oracle from pypyodbc import pypyodbc as pyodbc connstr = 'DSN = IDW;PWD=XXXXX' connection = pyodbc.connect(connstr) errs out with the below: File…
schuler
  • 175
  • 2
  • 4
  • 12
0
votes
1 answer

Using postgres thru ODBC in python 2.7

I have installed Postgres.app and started it. I have pip installed pypyodbc I have copied the hello world lines from the Pypyodbc docs, and received the error below. any ideas what the issue might be? Here is my code from __future__ import…
Dan Oblinger
  • 489
  • 3
  • 15
0
votes
2 answers

ValueError: could not convert string to float: E-3

I am trying to access some of the columns in a Microsoft Access database table which contains numbers of type double but I am getting the error mentioned in the title.The code used for querying the database is as below, the error is occurring in the…
nipidon
  • 1
  • 5
0
votes
2 answers

Hebrew appears as gibberish, DB importing with PyPyODBC

I'm trying to work with a Hebrew database, unfortunately the output is gibberish. What am I doing wrong? # -*- coding: utf-8 -*- import pypyodbc conn = pypyodbc.connect('Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\client.mdb') cur =…
RoyEsh
  • 245
  • 1
  • 4
  • 10
0
votes
1 answer

How to query in database using the value of dictionary in python?

For example I have my dictionary: my_dict = {'2':'even','1':'odd','3':'odd'} And this is my database: +---------+--------+ | Numeric | String | +---------+--------+ | 5 | five | | 4 | four | | 3 | three | | 2 | two …
user4501264
0
votes
1 answer

error of creating a stored procedure in netezza database from python by pypyodbc

I am working on python (pydev) in Eclipse on win7. I need to access netezza SQL database from python (pypyodbc) to create a stored procedure. I can create the stored procedure well from IBM Aginity workbench. But, I got error of I do this from…
user3601704
  • 753
  • 1
  • 14
  • 46
0
votes
1 answer

strange results returned with unix odbc and pypyodbc

I have odbc set up to query a Microsoft SQL server instance. My SQL statement run's fine from the isql command line; however, when i use the same query in pypyodbc the results are incorrect. What's unique about my query is that I have a nested left…
yee379
  • 6,498
  • 10
  • 56
  • 101
0
votes
1 answer

pyodbc connection failure on linux

I am trying to connect to a database using pyodbc,following code is working fine on windows,trying to run the same on linux is giving an error as follows,can anyone suggest what is wrong here and how to fix it? import pypyodbc as…
user3654069
  • 345
  • 2
  • 6
  • 14
0
votes
1 answer

Insert Statement error for Access Database

I'm trying to add data to a database (well MS Access) using python with pypyodbc. I've tested my insert statement in MS Access as a query and it works. The problem is when I run it inside my programme it brings up the following…
user2862873
  • 41
  • 1
  • 4
0
votes
3 answers

python 3.3, pypyodbc, connecting to SQL Server Fails

I am using python 3.3 + pypyodbc. When I try: connection = pypyodbc.connect("DRIVER{SQLServer}; SERVER=serverIP; UID=myid; PWD=mypwd; …
Sujit
  • 1
  • 1
  • 1
  • 1
1 2 3
…
18
19