Issue 257: not able to execute sql through microsoft access
Status:  Hold
Owner: ----
Reported by kamballa...@gmail.com, Apr 24, 2012
What steps will reproduce the problem?
1. running script in SQL in microsoft access database.
2. 3.

What is the expected output? What do you see instead?
all script should be executed and should be update in access database

What version of the product are you using? On what operating system?

Python 2.6.5 and PYODBC 2.1.1.7

Please provide any additional information below.


screenshot in window.JPG
315 KB   View   Download
Apr 24, 2012
#1 jiangwen...@gmail.com
Did you set autocommit to True?
if not, please try:
dbCon=pyodbc.connect(your_connection_string,autocommit=True) 

this might solve your problem.
Jun 23, 2012
Project Member #2 mkleehammer
Please try the latest version of pyodbc.  The version you are using is very old.

If it still fails, an ODBC trace would be very helpful.

Thanks.

Status: Hold