Rolthar / pyodbc

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

Disconnect ignores changes to the DB Ms Access #254

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.Cursor.close()
2.Connection.close()
3.

What is the expected output? What do you see instead?
When Connect see previous changes

What version of the product are you using? On what operating system?
Windows : XP
pyodbc  : pyodbc-3.0.5.win32-py2.7.exe
Python  : 2.7.1
MsAccess: 2000

Please provide any additional information below.
variables are set before executing below:
dbCon=pyodbc.connect('DSN=MS_ACCESS;DBQ='+dbDir+PWD='+str(dbPassword)+';autocomm
it=True') 

Original issue reported on code.google.com by chalho...@hotmail.com on 17 Apr 2012 at 6:48

GoogleCodeExporter commented 8 years ago
Hi, I think if you  change your connection to 

dbCon=pyodbc.connect('DSN=MS_ACCESS;DBQ='+dbDir+PWD='+str(dbPassword),autocommit
=True) 

would solve the problem.

Original comment by jiangwen...@gmail.com on 18 Apr 2012 at 11:00

GoogleCodeExporter commented 8 years ago
Thank you jiangwen it worked

Original comment by chalho...@hotmail.com on 18 Apr 2012 at 1:37

GoogleCodeExporter commented 8 years ago

Original comment by mkleehammer on 27 Sep 2012 at 8:35