[Tutor] Talking to mssql?

[Ryan Davis]

I couldn't compile it either, but got it working by copying the MSSQL.py and bin/python2.3/mssqldb.pyd from the archive to my
site-packages directory.

He scarcely mentions that option at the bottom of the install page:
http://www.object-craft.com.au/projects/mssql/install.html.

Not sure if the binary would work on Linux, though.

Thanks,
Ryan 

-----Original Message-----
From: tutor-bounces at python.org [mailto:tutor-bounces at python.org] On Behalf Of j2
Sent: Friday, April 08, 2005 6:51 PM
To: tutor at python.org
Subject: RE: [Tutor] Talking to mssql?

>I had the same question.  The best I found is this:
>http://www.object-craft.com.au/projects/mssql/ 
>but that has a lot of strong language saying "this isn't ready for use".
>
>I found it perfectly usable for simply running queries, but haven't tried
>to do anything more complicated with it.  Not sure how
>well it works on Linux, but he has binaries that worked for me.

Well, doesn't fly for me, because I can't install it. Can you offer any help
on the below?


I am trying to install http://www.object-craft.com.au/projects/mssql/ on my
Debian system, but when i try to build, i end up with the below. Also, my
package list is at the bottom.

hooch:~/Download/Asterisk/MSSQL-0.09# python setup.py install
running install
running build
running build_py
not copying MSSQL.py (output up-to-date)
running build_ext
building 'mssqldb' extension
creating build/temp.linux-i686-2.2
gcc -DNDEBUG -g -O3 -fno-strict-aliasing -Wall -Wstrict-prototypes -fPIC
-DHAVE_FREETDS -DHAVE_DBALTBIND -DHAVE_DBCLROPT -DHAVE_DBCURCMD
-DHAVE_DBCURROW -DHAVE_DBISOPT -DHAVE_DBNUMCOMPUTE -DHAVE_DBRETTYPE
-I/usr/include -I/usr/include/python2.2 -c mssqldb.c -o
build/temp.linux-i686-2.2/mssqldb.o
gcc -DNDEBUG -g -O3 -fno-strict-aliasing -Wall -Wstrict-prototypes -fPIC
-DHAVE_FREETDS -DHAVE_DBALTBIND -DHAVE_DBCLROPT -DHAVE_DBCURCMD
-DHAVE_DBCURROW -DHAVE_DBISOPT -DHAVE_DBNUMCOMPUTE -DHAVE_DBRETTYPE
-I/usr/include -I/usr/include/python2.2 -c loginrec.c -o
build/temp.linux-i686-2.2/loginrec.o
gcc -DNDEBUG -g -O3 -fno-strict-aliasing -Wall -Wstrict-prototypes -fPIC
-DHAVE_FREETDS -DHAVE_DBALTBIND -DHAVE_DBCLROPT -DHAVE_DBCURCMD
-DHAVE_DBCURROW -DHAVE_DBISOPT -DHAVE_DBNUMCOMPUTE -DHAVE_DBRETTYPE
-I/usr/include -I/usr/include/python2.2 -c dbproc.c -o
build/temp.linux-i686-2.2/dbproc.o
dbproc.c:199: warning: `wrap_DbProcIntFunc_bool' defined but not used
gcc -DNDEBUG -g -O3 -fno-strict-aliasing -Wall -Wstrict-prototypes -fPIC
-DHAVE_FREETDS -DHAVE_DBALTBIND -DHAVE_DBCLROPT -DHAVE_DBCURCMD
-DHAVE_DBCURROW -DHAVE_DBISOPT -DHAVE_DBNUMCOMPUTE -DHAVE_DBRETTYPE
-I/usr/include -I/usr/include/python2.2 -c databuf.c -o
build/temp.linux-i686-2.2/databuf.o
databuf.c: In function `get_buff_value':
databuf.c:86: error: `DBVARYCHAR' undeclared (first use in this function)
databuf.c:86: error: (Each undeclared identifier is reported only once
databuf.c:86: error: for each function it appears in.)
databuf.c:86: error: parse error before ')' token
databuf.c:87: error: parse error before ')' token
databuf.c:90: error: `DBBIT' undeclared (first use in this function)
databuf.c:90: error: parse error before ')' token
databuf.c: In function `DataBuf_set':
databuf.c:155: error: `DBVARYCHAR' undeclared (first use in this function)
databuf.c:155: error: parse error before ')' token
databuf.c:160: error: parse error before ')' token
databuf.c:161: error: parse error before ')' token
databuf.c:169: error: `DBBIT' undeclared (first use in this function)
databuf.c:169: error: parse error before ')' token
databuf.c: In function `DataBuf__init__':
databuf.c:270: error: `DBVARYCHAR' undeclared (first use in this function)
databuf.c:273: error: `DBBIT' undeclared (first use in this function)
error: command 'gcc' failed with exit status 1
hooch:~/Download/Asterisk/MSSQL-0.09#

_______________________________________________
Tutor maillist  -  Tutor at python.org
http://mail.python.org/mailman/listinfo/tutor