[egenix-users] Zope stops to respond

[Marcos Iuato]

I am trying to connect from a linux machine to a MS SQL Server, all the 
installation and configuration seems to be working, but when I run some 
query, the zope stops to respond. Someone knows what I am missing or 
could be wrong?

----------------------
:Packets and versions:
----------------------

debian:/opt/zopes/279-mxodbczopeda# dpkg -l|grep odbc
ii  odbcinst1      2.2.4-11       Support library and helper program for 
acces
ii  unixodbc       2.2.4-11       ODBC tools libraries

debian:/opt/zopes/279-mxodbczopeda# dpkg -l|grep "MS SQL"
ii  libct1         0.61-6.2       libraries for connecting to MS SQL and 
Sybas
ii  sqsh           2.1-6          commandline SQL client for MS SQL and 
Sybase

Zope Version
(Zope 2.7.9-final, python 2.3.5, linux2)
Python Version	
2.3.5 (#2, Sep 4 2005, 22:01:42) [GCC 3.3.5 (Debian 1:3.3.5-13)]

mxODBCZopeDA-1.0.10

---------------
:Configuration:
---------------

debian:/etc# cat /etc/freetds/freetds.conf
[MONET]
        host = 192.168.0.130
        port = 1433
        tds version = 8.0

debian:/etc# cat /etc/odbc.ini
[mssql]
Driver = /usr/lib/odbc/libtdsodbc.so
Description = MS SQL running on monet
Trace = No
Servername = MONET
Database = AfariaDB


eGenix mxODBC Database Connection eGenix mxODBC Database Connection at 
/mssqlserver:

Connection Id  	 mssqlserver  	
Connection Title 		
Database Connection Source 	DSN=mssql 	
ODBC Manager/Driver 	unixODBC 	
Connection Information 	Connected database: SQL Server, unknown version
ODBC driver: libtdsodbc.so, 0.61 	
Database Timezone 	Local Time Zone 	
Connection Options 	

     * Database Warnings are reported as Python exceptions.
     * Connection uses transactions.
     * Time columns are returned as DateTime values.
     * Date/time columns are returned as Zope DateTime values.
     * Short integers are fetched as short integers.
     * NULL values are returned as None.
     * Scale 0 floats are converted to integers.
     * The first available result set is fetched in queries.
     * Don't ignore the max_rows query parameter (this is a Z SQL 
parameter).
	
Connection Pool 	Pool size: 1
Physical connections: 1 open
Total number of mxODBC connections/cursors: (1, 0)
	
Connection State 	connected (since 2006/10/10 12:36:20.323 GMT-3)

-------------------
:Testing with sqsh:
-------------------

debian:/opt/zopes/279-mxodbczopeda# sqsh -D AfariaDB -U samurai -S 
192.168.0.130
sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password:
1> select count(*) from a_class
2> go

  -----------
           85

(1 row affected)


Thanks in advance,
Marcos Iuato