[egenix-users] Zope stops to respond

[Marcos Iuato]

Enabling the log of freetds, i get:

2006-10-10 15:01:24.390802 processing result tokens.  marker is  fd(DONE)
2006-10-10 15:01:24.390839 inside tds_process_end() more_results = 0, 
was_cancelled = 0
2006-10-10 15:01:24.390883 inside tds_process_result_tokens() state is 
COMPLETED
SQLGetFunctions: fFunction is 999
odbc: not implemented: SQLGetInfo: option/type 10000(SQL_XOPEN_CLI_YEAR) 
[category Added for ODBC 3.x]
odbc: not implemented: SQLGetInfo: option/type 
81(SQL_GETDATA_EXTENSIONS) [category Driver Information]

Does it means that I can't use freetds to connect to an MS SQL Server 2000?


Marcos Iuato escreveu:
> 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
> 
> 
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> https://www.egenix.com/mailman/listinfo/egenix-users