[DB-SIG] Accessing MSSQL from Python
Marcos Sánchez Provencio
msanchez@grupoburke.com
03 Sep 2002 13:38:22 +0200
Not very brilliant, really.
Download freeTDS (2002-09-03)
ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/freetds-current.tgz
./configure --with-tdsver=7.0
make
sudo make install
sudo ldconfig
[verify that tsql is working. Use the NT Server name as server name. I
have an interfaces file in the sybase dir, but I don't think that info
is being used]
Download Sybase module (it deserves a name, IMO)
http://object-craft.com.au/projects/sybase/download/sybase-0.35pre1.tar.gz
export SYBASE=/usr/local/freetds
python setup.py build_ext -D WANT_THREADS -D HAVE_FREETDS -U
WANT_BULKCOPY
python setup.py install
Test from python.
El mar, 03-09-2002 a las 11:58, Dave Cole escribió:
>
> > Using these versions:
> > sybase-0.35pre1
> > freetds-current 2002-09-03
> > Debian GNU/Linux 3.0
> > MSSQL 7.0
> >
> >
> > The connection seems to work fine even retrieving 100K rows into
> > memory (no, I won't do that often).
> >
> > Thank you for all your help. Expect to hear from me.
>
> That is excellent news!
>
> Are you able to explain the steps you went through to get it working?
>
> - Dave
>
> --
> http://www.object-craft.com.au