odbc advice?

[Steve Holden]

"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/
-----------------------------------------------------------------------