From d6568b482966f99e2df0a96d893f7b8e6f639706 Mon Sep 17 00:00:00 2001 From: Paul Johnston Date: Fri, 26 Oct 2007 18:17:14 +0000 Subject: Make access dao detecting more reliable #828 --- lib/sqlalchemy/databases/access.py | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/databases/access.py b/lib/sqlalchemy/databases/access.py index c6e6107bf..d57c9fa9f 100644 --- a/lib/sqlalchemy/databases/access.py +++ b/lib/sqlalchemy/databases/access.py @@ -190,13 +190,19 @@ class AccessDialect(default.DefaultDialect): self._dtbs = None def dbapi(cls): - import win32com.client - win32com.client.gencache.EnsureModule('{00025E01-0000-0000-C000-000000000046}', 0, 5, 0) + import win32com.client, pythoncom global const, daoEngine if const is None: const = win32com.client.constants - daoEngine = win32com.client.Dispatch('DAO.DBEngine.36') + for suffix in (".36", ".35", ".30"): + try: + daoEngine = win32com.client.gencache.EnsureDispatch("DAO.DBEngine" + suffix) + break + except pythoncom.com_error: + pass + else: + raise exceptions.InvalidRequestError("Can't find a DB engine. Check http://support.microsoft.com/kb/239114 for details.") import pyodbc as module return module -- cgit v1.2.1