Corrupt mxODBC installation?

[M.-A. Lemburg]

Jose Correia wrote:
> Decided to finally upgrade to Python 2.2.1 (from 1.5.2) and downloaded
> latest versions of everything incl mxBase 2.0.3 and mxODBC 2.0.4 Windows
> installer packages.
> 
> Problem is the mxODBC module seems to be corrupt.  The mx stuff is installed
> under the \site-packages\mx\ directory.
> Results on NT4 SP6 with (ActiveState) Python 2.2.1 build 222 installed:
> 
> 
>>>>sys.path
>>>
> ['', 'D:\\Python\\lib\\site-packages\\Pythonwin',
> 'D:\\Python\\lib\\site-packages\\win32',
> 'D:\\Python\\lib\\site-packages\\win32\\lib',
> 'D:\\Python\\lib\\site-packages',
> 'D:\\Python\\DLLs', 'D:\\Python\\lib',
> 'D:\\Python\\lib\\lib-tk', 'D:\\Python']
> 
> 
>>>>import mx.ODBC.Windows
>>>
> 
>>>>dbc = mx.ODBC.Windows.Connect('configdb', user='', password='',
>>>
> clear_auto_commit=0)
> Traceback (most recent call last):
>   File "<interactive input>", line 1, in ?
> AttributeError: 'module' object has no attribute 'Connect'
> 
> 
>>>>mx.ODBC.Windows
>>>
> <module 'mx.ODBC.Windows' from 'mx\ODBC\Windows\__init__.pyc'>
> 
>>>>mx.ODBC.Windows.__file__
>>>
> 'mx\\ODBC\\Windows\\__init__.pyc'
> 
> 
>>>>dir(mx.ODBC.Windows)
>>>
> ['__builtins__', '__doc__', '__file__', '__name__', '__path__']
> 
> 
> 
> This last bit shows that there is indeed no "Connect" in the module.  My
> previous version (also 1.5.2) on another machine shows loads of
> functions,etc when I used the dir() command on it.

Could it be that Python is still picking up some not 100%
uninstalled version of mxODBC on the machine ?

Try running Python in verbose mode to have it print out the
paths it tries for finding the modules:

python -vv

> Does this sound like there's a problem with the module or am I completely
> missing something here?
> 
> Been googling for prior version of the package but couldn't find any
> anywhere. 

Versions prior to mxODBC 2.0 are no longer available on the web.
The egenix-mx-commercial Windows installers are around 196kB in
size, so the size you reported looks odd.

-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
_______________________________________________________________________
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/