Top "Pyodbc" questions

In Python, Using pyodbc, How Do You Perform Transactions?

I have a username which I must change in numerous (up to ~25) tables. (Yeah, I know.) An atomic transaction seems …

python transactions pyodbc

SQL Server, Python, and OS X

What's a good way to interface Python running on OS X with a cloud-based SQL Server database? EDIT: With pyodbc …

python sql-server macos pyodbc

Connecting to MS Access 2007 (.accdb) database using pyodbc

I am on Win7 x64, using Python 2.7.1 x64. I am porting an application I created in VC++ to Python for …

python ms-access 64-bit pyodbc

pyodbc.connect timeout argument is ignored for calls to SQL Server

I am using pyodbc on Linux with FreeTDS to connect to SQL Server 2005. I have noticed that the timeout argument …

python sql-server-2005 pyodbc

Can I use multiple cursors on one connection with pyodbc and MS SQL Server?

I'm using pyodbc on python 2.6 to connect to Microsoft SQL Server 2005. I open a connection, create a couple of cursors: …

python sql-server pyodbc

Working with an Access database in Python on non-Windows platform (Linux or Mac)

I want to access the data in a Microsoft Access database. I have some .accdb and .mdb files and want …

python macos ms-access odbc pyodbc

Read stored procedure select results into pandas dataframe

Given: CREATE PROCEDURE my_procedure @Param INT AS SELECT Col1, Col2 FROM Table WHERE Col2 = @Param I would like to …

sql-server stored-procedures pandas sqlalchemy pyodbc

using pyodbc on linux to insert unicode or utf-8 chars in a nvarchar mssql field

I am using Ubuntu 9.04 I have installed the following package versions: unixodbc and unixodbc-dev: 2.2.11-16build3 tdsodbc: 0.82-4 libsybdb5: 0.82-4 …

python sql-server unicode utf-8 pyodbc

Does pyodbc support any form of named parameters?

I know sqlite3 has data = {'test_col': 012345679} sqlite3_conn.execute(""" UPDATE test_db SET test_col = :test_col ;""", data) and …

python mysql sql pyodbc

Check if pyodbc connection is open or closed

I often get this error: ProgrammingError: The cursor's connection has been closed. Is there a way to check whether the …

python mysql odbc pyodbc