A DB-API 2.0 module for accessing data sources via Microsoft ADO
Questions tagged [adodbapi]
43 questions
0
votes
1 answer
SQL Server Compact connection error in Python
connstr = """Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;DataSource=first.sdf;"""
conn = adodbapi.connect(connstr)
cur = conn.cursor()
getresult="select * from ft"
cur.execute(getresult)
result=cur.fetchall()
How can I solve the following…
waqar mumtaz
- 41
- 5
0
votes
1 answer
Why VBA can use ACE.OLEDB provider which is not unregistered?
I have Office installed by the OLEDB provider "Microsoft.ACE.OLEDB.15.0;" is not registered (I cannot see it from the list from the powershell attached below)
However, in Excel VBA, I can create and connect to a data source with this ACE provider in…
palazzo train
- 3,229
- 1
- 19
- 40
0
votes
0 answers
python.exe crashes while executing query from server
I'm trying to execute tiny mdx query from Analysis Service server at work.
Server provides data via ms ole db, not odbc specification, thats why i use adodbapi library.
Here's the function i use to obtain result from query execution:
def mdx_query…
0
votes
0 answers
Capture STATISTICS IO output from ADODBAPI in Python
I have the following demonstration code that works just fine but I want to capture the output of STATISTICS IO. I cannot find the proper way to capture this.
import adodbapi
server = 'MYCOMPUTER\SQLEXPRESS'
database = 'mytest'
connString =…
Russ960
- 1,109
- 2
- 17
- 33
0
votes
1 answer
python ADO DB API gives MS SQL cursor engine out of memory error. What is an alternative to python ado db api?
I am currently using python with adodb api for MS Sql database connection. This is working very well for smaller databases. But for large databases when the query is returning huge data, I get MS Sql cursor out of memory error. This works fine with…
sam
- 11
- 1
- 5
0
votes
0 answers
Reading MDB files from 64bit Python on a machine with 32bit MS Office
I want to read the contents of a series of MS Access databases from a 64bit Python application under Windows.
The machine on which I want to do this has 32bit versions of various MS Office applications installed (but not Access). This prevents my…
Andrew McLean
- 383
- 4
- 11
0
votes
1 answer
Error importing adodbapi: "No such key..."
I would dearly love to use the adodbapi module, but I can't get it to import. The latest version for Python 3.2 32 bits appears to have a syntax error:
Traceback (most recent call last):
File "C:\Program Files (x86)\JetBrains\PyCharm Community…
ROBERT RICHARDSON
- 2,077
- 4
- 24
- 57
0
votes
3 answers
getting pywin32 to work inside open office 2.4 built in python 2.3 interpreter
I need to update data to a mssql 2005 database so I have decided to use adodbapi, which is supposed to come built into the standard installation of python 2.1.1 and greater.
It needs pywin32 to work correctly and the open office python 2.3…
Setori
- 10,326
- 11
- 40
- 46
0
votes
1 answer
interacting between modules / classes in wxPython
I have a task of migrating a multi-userframe VBA project with a lot od database interaction into something different - as this must be something that cannot demand installing software (so JRE and .NET are out of the question) I believe this can be…
aPinchOfInsomnia
- 47
- 2
- 9
0
votes
0 answers
Getting SQL Server DateTime NULL into pandas
I have a table in a SQL Server which contains, among other things, a DateTime column From_UTC and a DateTime NULL column To_UTC. I try to read it into a pandas DataFrame.
The non-NULL column comes in fine as a datetime64, but the other gets datatype…
Bjarke Ebert
- 1,920
- 18
- 26
0
votes
2 answers
How do i correctly query a sql ce 4.0 database file using adodbapi?
I have the following method:
def open(self, filename):
if not os.path.exists(filename):
raise IOError("Cannot find Game Database file {0}").__format__(filename)
connstr = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;
…
gvoysey
- 516
- 1
- 4
- 15
0
votes
1 answer
Set up and connect to local SQLEXPRESS database using SQL Server Management Studio 2008 r2 and adodbapi
For testing purposes, I am attempting to setup a SQL Server database on my local machine and connect to it using adodbapi in Python. I used SQL Server Management Studio 2008 r2 to create a database and table. I enabled the SQL Server Browser…
bluefoot
- 189
- 2
- 11
0
votes
1 answer
Use of "Key" with adodbapi connection to MS Access
I have some code that links to Access and works fine with adodbapi, except for one niggling issue which I cant resolve. Basically I want to create a new table in Access with the Column Headings "Key" and "Value" but it doenst seem to work unless I…
FuriousG
- 1
- 1