search

tmolomby / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

not able to execute sql through microsoft access #257

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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.

Original issue reported on code.google.com by kamballa...@gmail.com on 24 Apr 2012 at 7:58

Attachments:

GoogleCodeExporter commented 9 years ago 
Did you set autocommit to True?
if not, please try:
dbCon=pyodbc.connect(your_connection_string,autocommit=True) 

this might solve your problem.

Original comment by jiangwen...@gmail.com on 24 Apr 2012 at 11:42

GoogleCodeExporter commented 9 years ago 
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.

Original comment by mkleehammer on 23 Jun 2012 at 9:38