odbc advice?

[don]

Obviously you saw the need, so I don't have to tell you how helpful your
book is. I'm a big fan. I hope it sells a million copies.

I did look at mx and will probably switch over now.


"Steve Holden" <sholden at holdenweb.com> wrote in message
news:uXBC8.45889$m26.19583 at atlpnn01.usenetserver.com...
> "don" <donald.braman at yale.edu> wrote ...
> > I'm trying to update table in a SQL Server 2000 database. The following
> (and
> > other similar) code hangs Python about half of the time when I run it
and
> > then, once hung, will hang every time until I reboot. Does anyone have
any
> > tips on handling odbc connections in Python? I've been hunting around
for
> a
> > while, but haven't found descriptions of hangs like this. My reference
of
> > choice (Python Web Programming) tells me the ODBC driver isn't ready for
> > prime-time. I'm not sure I have any other options, though. Any help
> > appreciated. -Don
> >
> > ++++++++++++++++++++++++
> >
> > import dbi, odbc
> >
> > conn = odbc.odbc('mydb')
> >
> > cur = conn.cursor()
> >
> > cur.execute("""UPDATE Cases SET Cases.Opinion = NULL WHERE
> > updateopinion=1""")
> >
>
> mxODBC from www.egenix.com is great, and free for non-commercial purposes.
>
> If this is a commercial task, I can't imagine many circumstances under
which
> the cost of the license wouldn't be immediately repaid by lack of hassle
on
> the ODBC front.
>
> One other option, if you have a compiler, etc., would be to try
recompiling
> Dave Cole's Sybase module in the SQl Server environment. Some time ago
there
> was sufficient commonality between the products that this worked, but I've
> heard no recent reports. Then you wouldn't need ODBC at all.
>
> Great choice of reference material, by the way ;-)
>
> regards
>  Steve
> --
> -----------------------------------------------------------------------
> Steve Holden                                 http://www.holdenweb.com/
> Python Web Programming                http://pydish.holdenweb.com/pwp/
> -----------------------------------------------------------------------
>
>
>
>
>