[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