Top "Pyodbc" questions

pyodbc is a module that allows you to use Python to make a database connection using ODBC

Is it possible for 64-bit pyodbc to talk to 32-bit MS access database?

I am using 64-bit python anaconda v4.4 which runs python v3. I have MS Access 2016 32-bit version. I would like …

python ms-access odbc 32bit-64bit pyodbc
"Optional feature not implemented (106) (SQLBindParameter)" error with pyodbc

I'm being driven nuts trying to figure this one out. I'm using Python for the first time, and trying to …

python ms-access-2010 pyodbc pypyodbc
How to get the last created ID in SQL

I created a table called participant composed by participant_ID (which is the primary key and is identity[has an …

python sql sql-server pyodbc
how connect to vertica using pyodbc

I've read the iODBC documentation regarding the odbc.ini, and the Vertica documentation. I also saw a question with the …

python pyodbc unixodbc vertica
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 …

python python-3.4 pyodbc pypyodbc
Cannot import pyodbc on Mac

I am unable to import pyodbc on my Macbook Pro (running Mac OS X 10.10.5) and python version 2.7.10. I used pip …

python macos python-2.7 odbc pyodbc
Neither DSN nor SERVER keyword supplied

I am trying to connect to SQL database slightly different ways: with and without use of parameter. Why without use …

python python-3.x pyodbc dsn
make python wait for stored procedure to finish executing

I have a python script that uses pyodbc to call an MSSQL stored procedure, like so: cursor.execute("exec MyProcedure @…

python sql sql-server stored-procedures pyodbc
PyODBC and Microsoft Access: Inconsistent results from simple query

I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program. …

python ms-access odbc jet pyodbc
How do I configure pyodbc to correctly accept strings from SQL Server using freeTDS and unixODBC?

I can not get a valid string from an MSSQL server into python. I believe there is an encoding mismatch …

sql-server-2008 unicode pyodbc freetds unixodbc