Win32.client, DAO.DBEngine and exceeding the file sharing countlock
in [Python]
|
Prev: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
Next: Spell suggest for locations
From: Tim Golden on 2 Jul 2008 10:29 Iain King wrote: > Hi. I'm using the win32 module to access an Access database, but I'm > running into the File Sharing lock count as in http://support.microsoft.com/kb/815281 > The solution I'd like to use is the one where you can temporarily > override the setting using (if we were in VB): > > DAO.DBEngine.SetOption dbmaxlocksperfile,15000 Really hurried answer: <code> import win32com.client dao = win32com.client.gencache.EnsureDispatch ("DAO.DBEngine.36") dao.SetOption (Option=win32com.client.constants.dbMaxLocksPerFile, Value=15000) </code> TJG
From: Tim Golden on 2 Jul 2008 12:18 Iain King wrote: > On Jul 2, 3:29 pm, Tim Golden <m...(a)timgolden.me.uk> wrote: >> Iain King wrote: >>> Hi. I'm using the win32 module to access an Access database, but I'm >>> running into the File Sharing lock count as inhttp://support.microsoft.com/kb/815281 >>> The solution I'd like to use is the one where you can temporarily >>> override the setting using (if we were in VB): >>> DAO.DBEngine.SetOption dbmaxlocksperfile,15000 >> Really hurried answer: >> >> <code> >> import win32com.client >> >> dao = win32com.client.gencache.EnsureDispatch ("DAO.DBEngine.36") >> dao.SetOption (Option=win32com.client.constants.dbMaxLocksPerFile, Value=15000) >> >> </code> >> TJG > > Thanks. I found this: http://blogs.msdn.com/michkap/archive/2007/07/13/3849288.aspx > which outlines some difference between DAO and ADO, including: > "Capability to set and change Jet options without making registry > changes (works in DAO through DBEngine.GetOption and > DBEngine.SetOption, fails in ADO, which has no such analogue)." > > Now, I'm pretty sure I tried to use DAO before and failed to get it to > work, but maybe you could look at my code and suggest the DAO > equivalent? I'm afraid I don't have the relevant experience myself. I'm sure I could muddle through a few web pages and work it out (but I'm sure you could, too!) Sorry TJG > aTdHvAaNnKcSe, PS - Like the .sig
From: M.-A. Lemburg on 2 Jul 2008 13:30 On 2008-07-02 16:54, Iain King wrote: > On Jul 2, 3:29 pm, Tim Golden <m...(a)timgolden.me.uk> wrote: >> Iain King wrote: >>> Hi. I'm using the win32 module to access an Access database, but I'm >>> running into the File Sharing lock count as inhttp://support.microsoft.com/kb/815281 >>> The solution I'd like to use is the one where you can temporarily >>> override the setting using (if we were in VB): >>> DAO.DBEngine.SetOption dbmaxlocksperfile,15000 >> Really hurried answer: >> >> <code> >> import win32com.client >> >> dao = win32com.client.gencache.EnsureDispatch ("DAO.DBEngine.36") >> dao.SetOption (Option=win32com.client.constants.dbMaxLocksPerFile, Value=15000) >> >> </code> >> TJG > > Thanks. I found this: http://blogs.msdn.com/michkap/archive/2007/07/13/3849288.aspx > which outlines some difference between DAO and ADO, including: > "Capability to set and change Jet options without making registry > changes (works in DAO through DBEngine.GetOption and > DBEngine.SetOption, fails in ADO, which has no such analogue)." You could try to use the Access ODBC driver and access the database that way via mxODBC. That would be faster as well: http://www.microsoft.com/technet/prodtechnol/windows2000serv/technologies/iis/reskit/iischp7.mspx (scroll down to table 7.1) Apart from that option and if you are really in need for larger transactions, I'd suggest that you move to SQL Server for processing (if you can). Access is not really made for heavy-lifting and big transactions. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jul 02 2008) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ 2008-07-07: EuroPython 2008, Vilnius, Lithuania 4 days to go :::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611
From: Tim Golden on 2 Jul 2008 15:13
In case it helps, there's a recipe just shown up on the Python Cookbook which at least illustrates DAO use: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/572165 TJG |