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

SQL Server error - Operand type clash: ntext is incompatible with int - (I'm not even using "ntext")

One of the columns I'm operating on is: Comments VARCHAR(8000) So basically I'm trying to insert a large text of up to even 600 characters into this column Comments. When I run my script everything goes smoothly for first 10 rows then all of a…
90abyss
  • 7,037
  • 19
  • 63
  • 94
2
votes
2 answers

Configure ODBC drivers in Linux

I've followed all the steps from this link: https://code.google.com/p/pypyodbc/wiki/Linux_ODBC_in_3_steps But I'm still getting this error: [unixODBC][Driver Manager] Data source name not found, and no default driver specified Then when I…
90abyss
  • 7,037
  • 19
  • 63
  • 94
2
votes
2 answers

Can I work with both local and ODBC linked tables in an Access database from Python?

How can pypyodbc connect to linked tables in the .accdb database? Is this possible at all, or is this a limitation of pyodbc? I need to get data from an MS Acess .accdb database into Python. This works perfectly and I can use pypyodbc to access…
MB-F
  • 22,770
  • 4
  • 61
  • 116
2
votes
1 answer

"Invalid precision or scale value" error from SQL Server with pypyodbc for Decimal('0.00'), Decimal('0.12')

I am developing an application in python. I am inserting some financial data into database. I have approx. 1300 tables all with same schema, one table for each company. I am using pypyodbc 1.3.3(latest). I have Decimal as datatype. I am using…
ajay_t
  • 2,347
  • 7
  • 37
  • 62
2
votes
3 answers

SQLAlchemy orm styles, how to make special drive to your connection string

I use pypy, pypyodbc and SQLAlchemy. I have problem of odbc connections. I use: engine = create_engine('mssql+pyodbc://dbuser:dbpasswd@localhost/dbname', echo = False) Session = sessionmaker(bind=engine) style try to connect the database. The error…
user504909
  • 9,119
  • 12
  • 60
  • 109
2
votes
0 answers

pyodbc.ProgrammingError: ('HY000', 'The SQL contains 0 parameter markers,

There are connection with Oracle (works good): import pypyodbc as pyodbc cnxn=pyodbc.connect("DSN=ORCL;PWD=user1") cursor=cnxn.cursor() cursor.execute("select * from t_v01") s = 'sss' f = 'fff' cursor.execute("select * from t_v01 where t_id = ?…
Dan Ko
  • 21
  • 2
2
votes
1 answer

How to download PYODBC on Python 3.4

I've been trying to download PYODBC 1.3 onto Python 3.4 for about 2 weeks. I've gone to: https://pypi.python.org/pypi/pypyodbc/1.3.0 to download the folders. When I run the easy_install.py and pyodbc.py, it seems to run fine. But then when I try to…
BillyMadison
  • 93
  • 2
  • 10
2
votes
1 answer

pypyodbc cursor.execute() List index out of range

It's late, I'm tired - I hope I am just making a stupid mistake but I can't seem to see it. Can anyone see what I may be doing wrong? If I run the SQL on SQL Server Management studio, it works fine. I can run other SQL statements against the cursor,…
SteveJ
  • 3,034
  • 2
  • 27
  • 47
2
votes
1 answer

pypyodbc doesn't connect when isql does?

pypyodbc has worked for me in the past, but for some reason it's not working. I have this defined in ~/.odbc.ini [as400] Description = IBM i Access ODBC Driver …
Wayne Werner
  • 49,299
  • 29
  • 200
  • 290
2
votes
0 answers

SQLAchemy is never able to locate specified column in row

I'm new to SQLAlchemy (but not ORM's in general) and running into an issue where I literally cannot do anything useful. All I'm able to do is hard code my query, which is what I want to do. Here is exactly what I'm attempting to do (see Python…
self.
  • 1,612
  • 4
  • 18
  • 35
2
votes
0 answers

No. of open connections with a database

I want to get the count of no. of connections currently open with an ms-access database. For example two applications are working with the same database. Then how can I get this count? Is there is ms-access function or any facility in…
hsvyas4u
  • 158
  • 2
  • 9
2
votes
1 answer

Failed to create database error pypyodbc

I've installed pypyodbc to create and modify Access Databases. However, following the tutorials I am getting the following error: Traceback (most recent call last): File "", line 1, in …
user2862873
  • 41
  • 1
  • 4
2
votes
1 answer

error - pypyodbc.win_create_mdb inside multi-levels folder

>>> pypyodbc.win_create_mdb('E:/Database/Japan/201112.mdb') Its working fine for double-levels but there is an error when I create tripper-level folders error. Would you shade me a light> Thanks. MS Access library for python >>> import pypyodbc …
ケンジ リュスケ
  • 107
  • 1
  • 10
2
votes
1 answer

How to use FetchAll in PyPyODBC Module for Python?

I am trying to use PyPyODBC, specifically a take on this example. However, I am not interested in creating a new table, I simply want to read the data (which resides in a database/table in SQL Server) and work with it inside of Python. The below…
Student
  • 1,197
  • 4
  • 22
  • 39
2
votes
3 answers

Python pypyodbc how do I insert variables to the execute statement?

I am working with Python 3.3, pypyodbc 1.2.1, and a Quickbooks Enterprise 12 company file being access over Flexquarters QODBC version 14. I'm new to programming and python, so still learning :) I can run a query using the pypyodbc examples just…
MLindsay
  • 118
  • 3
  • 8
1 2 3
…
18 19