pyodbc

Hi everyone, This group is rarely used anymore, so I am archiving it for now. Please use the Github

Do you know who would executemany() would work?

Greetings, I ran print(pyodbc.drivers()) It returns: ['SQL Server', 'SQL Server Native

Hi , I'm using below script to install pyodbc and other drivers %sh curl https://packages.

Hi, I have a query adding few( many) rows simultaneously using the cursor.execute( string, list)

I tried the following but it didn't work: import pyodbc import pickle server = 'localhost

Yes, I got the solution from stackoverflow. 'commit' is an object method. So, my commit call

You have probably solved your problem by now, but if you haven't you might try adding db = None

I solved my issue by reading this: https://github.com/mkleehammer/pyodbc/wiki/Unicode So for the

Hello friends, I'm trying to fetch all view definitions defined in a Netezza database using

Hi again, I took time to read pyodbc code and odbc & python API reference and it seems that:

Hi Guys, I have a python script running under Kubuntu accessing a SQL Server DB running on a Windows

I'm trying to find the solution to this as well...

Hey all ! Using pyodbc to insert into a Kudu table using impala sql. Given this table: CREATE TABLE

Somebody please help me to connect to oracle sales cloud using python, as i am new to oracle sales

Hi I am using SQL Server 2016 as the DB and pyodbc with Python 2.7. I need to send a table as a

hi all. how can i copy a table from one ms access database to another. or just use "create table

Hello, I'm using pyodbc to connect to our Informix DBMS. I can connect but have troubles using

Hello Maurice: It did work! I installed he drivers, and connected to database being able to fetch all

you may precise your pyodcb version.

Hi, I had exactly the same issue. I created a connection to SQL server using pyodbc, then using

Hello everyone, First of all thank you for making pyodbc so awesome :) I have licensed the Progress

Hello, I am using Python and MSSQL to query a database that I did not create. I have run into a

Hello, I am using python 2.7. I am connecting MSSQL server using PyOdbc. I had used SQL Variant

There is a proposal open to discontinue pymssql development and point people towards pyodbc: https://

Also, it would be best to open an GitHub issue for things like this to get them noticed sooner.

That is an error from your driver, not from pyodbc. Apparently your driver (and most likely database)

Please try version 4.0.2 which has configurable encodings. See the updated Wiki and/or docs for more

If you are trying to use SQL Server's integrated authentication, use this: DRIVER={SQL Server};

Documentation is in the /docs directory - I can't publish them yet without replacing the 3.x line