| Issue 254: | Disconnect ignores changes to the DB Ms Access | |
| 1 person starred this issue and may be notified of changes. | Back to list |
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)+';autocommit=True')
Apr 18, 2012
Thank you jiangwen it worked
Sep 27, 2012
(No comment was entered for this change.)
Status:
NoFix
|
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.