Top "Pyodbc" questions

Connect pyodbc to Postgres

Trying to connect to Postgres using pyodbc. I can connect to the DB with isql: echo "select 1" | isql -v my-connector …

postgresql python-3.x ubuntu-14.04 pyodbc

Iterating over PyoDBC result without fetchall()

I'm trying to process a very large query with pyodbc and I need to iterate over the rows without loading …

python sql pyodbc

pyodbc - very slow bulk insert speed

With this table: CREATE TABLE test_insert ( col1 INT, col2 VARCHAR(10), col3 DATE ) the following code takes 40 seconds to run: …

sql-server bulkinsert pyodbc

Authenticate from Linux to Windows SQL Server with pyodbc

I am trying to connect from a linux machine to a windows SQL Server with pyodbc. I do have a …

python sql linux windows pyodbc

How to use Django with Sql Server

I normally use Postgres for my database needs with Django but I recently started at a company which use MSSQL …

django pyodbc django-pyodbc-azure

Cant Create tables in access with pyodbc

I am trying to create tables in a MS Access DB with python using pyodbc but when I run my …

python ms-access pyodbc

does pyodbc have any design advantages over pypyodbc?

I know pyodbc is an older project and probably more featureful and robust, but is there anything about its design (…

python odbc etl pyodbc pypyodbc

SQL IN operator using pyodbc and SQL Server

I'm using pyodbc to query to an SQL Server database import datetime import pyodbc conn = pyodbc.connect("Driver={SQL Server};…

python sql pyodbc

"Invalid parameter type" (numpy.int64) when inserting rows with executemany()

I try to insert bunch of data to database insert_list = [(1,1,1,1,1,1),(2,2,2,2,2,2),(3,3,3,3,3,3),....] #up to 10000 tuples in this list conn = pyodbc.connect(…

python sql-server numpy pyodbc freetds

"No driver name specified" writing pandas data frame into SQL Server table

I am trying to write a Pandas' DataFrame into an SQL Server table. Here is my example: import pyodbc import …

python sql-server pandas sqlalchemy pyodbc