Stack Overflow
Stack Overflow

Questions tagged [adodbapi]

A DB-API 2.0 module for accessing data sources via Microsoft ADO

43 questions
1
vote
1 answer

Getting SQL Server messages using ADO and win32com

I am currently trying to write a tool that will make it very easy for a non-computer literate user to backup a SQL Server database. To do this I am hoping to use an interesting mix of ADO, win32com and adodbapi. Currently I can easily connect to the…
thomas
  • 949
  • 6
  • 20
1
vote
0 answers

Python crashes when more than one parameter is passed to an SQL query

When using adodbapi 2.6 package on Windows 7, Python will crash (generate a "Python has stopped working" popup window) when more than one parameter is passed to a SQL query. I am trying to pass parameters to a ADO connection cursor to query an SQL…
johnDanger
  • 1,990
  • 16
  • 22
1
vote
1 answer

Resolving SQL type name error when using qmark style parameters?

I am attempting to make the following parameterized SQL query using a ADO connection through the adodbapi package and I am getting Type name is invalid database errors that I can not resolve. cursor.execute("SELECT * FROM ?", ["Compound"]) This…
johnDanger
  • 1,990
  • 16
  • 22
1
vote
1 answer

Why is does my cursor location need to be set to server side when connecting to a local sdf database?

I am connecting to a local SQL Server Compact database (.sdf file) on my desktop with the adodbapi package and the connector does not function properly unless the cursor is set to the "server side". Why is this the case? After looking at the…
johnDanger
  • 1,990
  • 16
  • 22
1
vote
2 answers

SQL CE connection with Python

Problem Statement: Extract data stored in the .sdf file to python. System config: Win 10 Pro 64-bit, python 3.5.2-64 bit, adodbapi library, SQL CE 3.5 I am fairly new to programming and I have picked up Python as my first language to learn.…
Jay Desai
  • 11
  • 1
  • 5
1
vote
1 answer

ADODBAPI No. Of Open Connection with 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
1
vote
3 answers

SQLAlchemy and adodbapi Database connection error

I'm attempting to connect to a mssql SQLExpress 2012 database using sqlalchemy 0.7.8 and adodapi 2.4.2.2 on IronPython 2.7.3 I am able to create a sqlalchemy engine, however when a query is made I get : "TypeError: 'NoneType' object is…
Sigma
  • 113
  • 1
  • 8
0
votes
0 answers

AttributeError: 'Nonetype' while creating dataframe using pandas

I am fetching data from database, and converting it to dataframe using pandas. I am getting AttributeError. Code: conn = adodbapi.connect("Provider=SQLNCLT11, Sever=LDN209232, Database = mydb, Integrated Security = SSPI, 180") cursor =…
ritik jain
  • 540
  • 1
  • 5
  • 13
0
votes
1 answer

Pywintypes error when running an adodbapi package python query

I am having difficulty installing adodbapi and running a script which uses SQL to connect and run a DAX query using adodbapi. I have run into this error on multiple machines.
Sanch
  • 367
  • 2
  • 11
0
votes
0 answers

Establish connection to Azure Analysis Services thru service principal using "adodbapi" Python library

I am trying to connect to Azure Analysis Service in Python using adodbapi. Using Application Service Principal. While I am able to connect and execute with my personal credentials, thru multi factor authentication. But, i am struck on how to…
Raja
  • 513
  • 5
  • 18
0
votes
1 answer

adodbapi SQL Server CE query crashes when selecting a specific column

After hours of headache I managed to connect to the .sdf database file with Python using adodbapi using this connection string: Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source={}; ssce:Database Password='{}'; only to get stuck into this…
dsl400
  • 322
  • 3
  • 14
0
votes
0 answers

How to get the IDENTITY value when using INSERT … OUTPUT with ADODBAPI

I am trying to get the ID of a newly inserted row by using OUTPUT. However, I am getting exception: fetch() on closed connection or empty query set. I am using adodbapi for SQL Server connectivity. Code: import adodbapi Query = ''' DECLARE…
user2961127
  • 963
  • 2
  • 17
  • 29
0
votes
1 answer

Unable to perform windows authentication for SQL Server using python

My Python code shown below is written to create a SQL Server connection using Windows authentication. I have constraints to use adodbapi library for database connectivity. Please can anyone tell me what is missing from this code? I referred to the…
user2961127
  • 963
  • 2
  • 17
  • 29
0
votes
1 answer

Can't open MS ACESS Database with ADOBDAPI

When I try to connect to an MS-Access database with Python ADODBAPI library, I have an error message. I have tried to use the Microsoft.ACE.OLEDB.12.0 provider but it's the same thing. I can open the database with the Microsoft.Jet.OLEDB.4.0…
Foxrider83
  • 21
  • 6
0
votes
1 answer

Connecting Python to SQL Server with SSMS and Windows Credentials

Here is a problem that I am facing while connecting to SQL Server database using python/adodbapi. We have a SQL Server test database that is in a different domain using the following method. runas /netonly /user:\ "C:\Program…
Keshav Prabhu
  • 83
  • 1
  • 11
1
2
3