Python and MS SQL (Microsoft SQL server)

[Guy L. Oliver]

im trying to do the same thing. there are commercial odbc drivers/managers
for unix, but the ones I found were quite expensive.  I gave up looking and
just wrote a bridge that would allow my code on the solaris box to remotely
call a server I wrote on a nt box that did the queries (using win32 odbc, or
ado, etc...), and returned the information to the solaris box.

If you (or anyone else reading this) find a good odbc bridge for solaris
that doesnt cost an arm and a leg, let me know.  the mxODBC package has some
odbc drivers available, and pointers to a driver manager for unix, but so
far, I havent found any thing to talk to sql server outside of intersolv's
unix drivers, which were, last time I checked, quite expensive.  and of
course, my project doesnt have much of a budget.  I found the little bridge
to be a passable solution to the problem, thought ymmv.

-G


"Dave Cinege" <dcinege at psychosis.com> wrote in message
news:3884C60B.BE820782 at psychosis.com...
> "George Thom at s" wrote:
> >
> > Hi Dave,
> > The odbc module that comes as part of the win32 extensions bundled with
> > Python 1.5.2 for the various flavours (!) of Windows should do just
fine.
>
> So you're saying python has to be runnign on NT for this to work?
>
> > Additional functionality (with some tweaking ... ymmv ;-) can be
obtained
> > with marc Lemburg's mxODBC module.
>
> What about this? we're looking to run on solaris or linux.
>