My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 254: Disconnect ignores changes to the DB Ms Access
1 person starred this issue and may be notified of changes. Back to list
Status:  NoFix
Owner:  ----
Closed:  Sep 2012


 
Reported by chalho...@hotmail.com, Apr 17, 2012
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
#1 jiangwen...@gmail.com
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.
Apr 18, 2012
#2 chalho...@hotmail.com
Thank you jiangwen it worked
Sep 27, 2012
Project Member #3 mkleehammer
(No comment was entered for this change.)
Status: NoFix

Powered by Google Project Hosting