odbc advice?

[don]

Hmmm...just did a quick search/review of ADO. Looks neat. I'm on a 2000 box
right now, but I think I'd like to keep the linux/bsd door open. Thanks for
the idea, though. -Don

"dsavitsk" <dsavitsk at e-coli.net> wrote in message
news:UrBC8.12217$d7.4156923 at newssrv26.news.prodigy.com...
> if you are on Win32, why not use ADO or ADO.NET?
> -d
>
> "don" <donald.braman at yale.edu> wrote in message
> news:abel0d$anh$1 at news.ycc.yale.edu...
> > 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""")
> >
> >
> >
>
>