How can this script fail?

[M.-A. Lemburg]

On 2008-08-27 13:15, boblatest at googlemail.com wrote:
> On Aug 27, 1:08 pm, "M.-A. Lemburg" <m... at egenix.com> wrote:
> 
>> I don't think this is related to IDLE or your setup. The odbc
>> module is very old and unmaintained, so it's possible that Windows
>> doesn't find some system DLLs needed for it to work.
> 
> Please note that
> 1) I can type "import odbc" directly into the IDLE shell without
> getting an error message,
> but only BEFORE I've run a script that tries to import odbc.

It is possible that the script import of the odbc module left
an uninitialized or half-initialized module object in sys.modules.

Another possibility is that IDLE and the script import different
modules with the same name due to problems on your sys.path (see
my first reply).

> 2) The same script runs fine under PyWin (which I don't like much as
> an environment).

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Aug 27 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/
________________________________________________________________________

:::: 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