newsgroup postings: cursor.execute fails under mxODBC

[M.-A. Lemburg]

[CCed to the Python newsgroup, since I believe this is of general
 interest; hope you don't mind.]

Louis Luangkesorn wrote:
> 
> Hello
> 
> This is regarding the mxODBC 2.0 module that you have been providing (by
> the way, thank you).  On the comp.lang.python newsgroup there has been
> some discussion regarding the trouble some of us have been having on
> using the mxODBC 2.0 packages under Windows (95, 98, 2000).  Referring
> to the Sunday 11 Marsh message from Brett Haydon, apparently something
> happened when the packages got updated to 2.0, so his installation works
> under 1.1.1 but failed when he installed the 2.0 packages.
> 
> I am wondering if this is a known problem with a fix, or if it is
> possible to obtain the 1.1.1 packages which seem to be more stable right
> now.

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.
 
> Sincerely,
> 
> Louis
> 
> PS note that my reference to changing the name of the odbc.pyc refers to
> the odbc.pyc that came with the win32 extensions.
> 
> -----<forwarded newsgroup message>-----
> Subject:                Re: cursor.execute fails under mxODBC
>          Date:                Sun, 11 Mar 2001 03:17:09 +1100
>          From:               "Brett Haydon" <bbhaydon at bigpond . com>
>  Organization:                Telstra BigPond Internet Services
> (http://www.bigpond.com)
>   Newsgroups:               comp.lang.python
>    References:                1 , 2 , 3
> 
> Hmmm looks like the new version is broken.
> 
> I am running mxODBC 1.1.1 no problems with both MySQL and Access
> for the last 6 months on W2k.
> 
> I just tried the new version also with exactly the same problems.
> 
> The old one still works fine though..
> 
> regards,
> 
> bbhaydon
> 
> Subject:                Re: cursor.execute fails under mxODBC
>          Date:                Thu, 08 Mar 2001 15:52:14 -0600
>          From:               Louis Luangkesorn <lluang at northwestern.edu>
> 
>  Organization:                Northwestern IE/MS
>   Newsgroups:                comp.lang.python
>    References:                1 , 2
> 
> I have the same problem.  Below is my output.  I will first use the odbc
> 
> that comes included with ActivePython, then the mxODBC module  (by the
> way,
> I've tried to rename the odbc.pyc file, that did not help, except break
> odbc)
> 
> PythonWin 2.0 (#8, Oct 19 2000, 11:30:05) [MSC 32 bit (Intel)] on win32.
> 
> Portions Copyright 1994-2000 Mark Hammond (MarkH at ActiveState.com) - see
> 'Help/About PythonWin' for further copyright information.
> >>>
> >>> import dbi,odbc
> >>> import pprint
> >>> channel = odbc.odbc('sqltutor')
> >>> ch1 = channel.cursor()
> >>> ch1.execute('SELECT FirstName, LastName, Address, City, State FROM
> EmployeeAddressTable')
> 0
> >>> test1 = ch1.fetchall()
> >>> pprint.pprint(test1)
> [('Joe', 'Smith', '83 First Street', 'Howard', 'Ohio'),
>  ('Mary', 'Scott ', '842 Vine Ave.', 'Losantiville', 'Ohio '),
>  ('Sam', 'Jones ', '33 Elm St.', 'Paris', 'New York '),
>  ('Sarah', 'Ackerman ', '440 U.S. 110', 'Upton', 'Michigan ')]
> >>> ch1.close()
> >>> channel.close()
> >>> import mx.ODBC
> >>> channel = mx.ODBC.Windows.connect('sqltutor')
> >>> ch1 = channel.cursor()
> >>> ch1.execute('SELECT FirstName, LastName, Address, City, State FROM
> EmployeeAddressTable')
> 
> at this point the whole thing dies.  No error messages.  I didn't see
> any
> log files anywhere either.
> 
> Louis
> 
> --
> 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

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