Python and MS SQL (Microsoft SQL server)

[M.-A. Lemburg]

Dave Cinege wrote:
> 
> "M.-A. Lemburg" wrote:
> >
> > Dave Cinege wrote:
> > >
> > > "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.
> >
> > Then you should probably try out the Sybase interface together
> > with the Sybase dev libs.
> 
> So you're saying the sybase interface works with

... MS SQL Server ?! Yes, it does from what I've heard. They both
use the same protocol (MS probably bought Sybase and renamed
it).
 
> mxODBC will only connect you to
> > local databases unless you let it talk to the DB through
> > an ODBC-ODBC bridge.
> 
> That sounds like a better solution. Can I do that using the unix ODBC thing
> that I've seen listing in the python modules page?

You could try the OpenLink or Intersolv driver sets or
the EasySoft ODBC-ODBC bridge. All are reported to work
together with mxODBC.

-- 
Marc-Andre Lemburg
______________________________________________________________________
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/