[Tutor] Talking to mssql?

2005-04-07 Thread j2
I need to talk to a MSSQL server from a python script on a Linux box... I
can't seem to find anything useful. 
I found http://adodbapi.sourceforge.net/ but that seem to be made for Python
Scripts on Windows?

___
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor


RE: [Tutor] Talking to mssql?

2005-04-08 Thread j2
>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@python.org
http://mail.python.org/mailman/listinfo/tutor


RE: [Tutor] Talking to mssql?

2005-04-09 Thread j2
>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#


+++-==-==-==
==
ii  adduser3.51   Add and remove users and groups
ii  apache 1.3.29.0.1-3   Versatile, high-performance HTTP
server
ii  apache-common  1.3.29.0.1-3   Support files for all Apache
webservers
ii  apache-utils   1.3.29.0.1-3   Utility programs for webservers
ii  apt0.5.4  Advanced front-end for dpkg
ii  apt-utils  0.5.4  APT utility programs
ii  arping 1.05-1 sends IP and/or ARP pings (to the
MAC address)
ii  asterisk   1.0.7.dfsg.1-2 open source Private Branch
Exchange (PBX)
ii  asterisk-config1.0.7.dfsg.1-2 config files for asterisk
ii  asterisk-prompt-se 0.8-2  Swedish voice prompts for Asterisk
ii  asterisk-sounds-ma 1.0.7.dfsg.1-2 sound files for asterisk
ii  at 3.1.8-11   Delayed job execution and batch
processing
ii  atftpd 0.6.2  Advanced TFTP server.
ii  aub2.1.3-1Assembles binary files from USENET
ii  autoconf   2.57-10automatic configure script builder
ii  autoconf2.13   2.13-48automatic configure script builder
(obsolete version
ii  automake   1.4-p4-1.1 A tool for generating GNU
Standards-compliant Makefi
ii  autoproject0.17-1 create a skeleton source package
for a new program
ii  autotools-dev  20030717.1 Update infrastructure for
config.{guess,sub} files
ii  backup2l   1.1-gk.1.1 low-maintenance backup/restore
tool for mountable me
ii  base-config1.72