cursor.execute fails under mxODBC

[M.-A. Lemburg]

Louis Luangkesorn wrote:
> 
> > Thank you for forwarding the messages. I have had numerous questions
> > about this problem and will look into it later this week (just came
> > back from the Python conference and am still fighting the jet lag).
> >
> > One thing I've noted about the problem reports is that all seem
> > to use ActiveState Python 2.0. There may be an issue here, since
> > the mxODBC (alas the egenix-commercial) package was compiled against
> > the BeOpen Python 2.0 version which is available from python.org.
> >
> > Could you perhaps check whether you experience the same problems
> > using BeOpen Python 2.0 ?
> >
> > Thanks,
> > Marc.
> 
> Marc
> 
> No, that did not work. Here it is under the BeOpen-Python-2.0  After the
> cursor.execute(...) the Python shell hangs.

I've uploaded a new version of the Windows installer to:

http://www.lemburg.com/files/python/egenix-mx-commercial-2.0.0.win32-py2.0.exe

There seems to have been some build error during the release
session which was introduced after the final tests. Please check
whether you still get the indicated problems with the new 
build.

One thing this teaches is that distutils should probably clear
the build directory before rebuilding a package... I'll add that
to my batch file.

Thank you for looking into this and sorry for the trouble 
this has caused you. I hope the new build works for you as well
(it does for me on Windows 9x -- don't have a W2k to test on).

--
Marc
 
> Louis
> ---begin output---
> Python 2.0 (#8, Oct 16 2000, 17:27:58) [MSC 32 bit (Intel)] on win32
> Type "copyright", "credits" or "license" for more information.
> IDLE 0.6 -- press F1 for help
> >>> import mx.ODBC.Windows
> >>> channel = mx.ODBC.Windows.Connect('sqltutor')
> 
> >>> cursor = channel.cursor()
> >>> cursor.execute('select FirstName, LastName, Address, City, State FROM
> EmployeeAddressTable')
> 
> ---end output---
> --
> K Louis Luangkesorn
> lluang at northwestern.edu  http://pubweb.nwu.edu/~kll560  PGP:0xF3E2D362
> 
> Whatsoever things are true, ... honest, ... just, ... pure, ... lovely, ... of
> good report; if there be any virtue, and if there be any praise, think on
> these things.
>      - motto - Northwestern University (Phil 4:8)

-- 
Marc-Andre Lemburg
______________________________________________________________________
Company & Consulting:                           http://www.egenix.com/
Python Pages:                           http://www.lemburg.com/python/