[egenix-users] Zope stops to respond

[Marcos Iuato]

Hi Jean,

I have installed the unixodbc-bin and freetds-dev, and made the 
configurations changes that you suggested, but it still not working. How 
can I debug that problem? Could somebody points some directions?

debian:/etc# dpkg -l|grep MS
ii  freetds-dev    0.61-6.2       MS SQL and Sybase client library 
(static lib
ii  libct1         0.61-6.2       libraries for connecting to MS SQL and 
Sybas
ii  libsybdb3      0.61-6.2       libraries for connecting to MS SQL and 
Sybas
ii  mtools         3.9.9-2.1      Tools for manipulating MSDOS files
ii  sqsh           2.1-6          commandline SQL client for MS SQL and 
Sybase

debian:/etc# dpkg -l|grep odbc
ii  gtkodbcconfig0 2.2.4-11       GTK-based ODBC configuration library
ii  libodbcinstq1  2.2.4-11       Qt-based ODBC configuration library
ii  odbcinst1      2.2.4-11       Support library and helper program for 
acces
ii  unixodbc       2.2.4-11       ODBC tools libraries
ii  unixodbc-bin   2.2.4-11       Graphical tools for ODBC management 
and brow
ii  unixodbc-dev   2.2.4-11       ODBC libraries for UNIX (development 
files)

Thanks in advance,
Marcos Iuato

BALTUS Jean escreveu:
> Hi, 
> 
> Install the development package for freetds (and unix-odbc-bin?):
> 
> apt-get -V install unixodbc
> apt-get -V install unixodbc-bin
> apt-get -V install freetds-dev
> 
> Also, in the freetds.conf file, you can add: 
> 
> client charset = strip high-order byte 
> 
> 
> Try to create a odbcinst.ini file : 
> 
> [FreeTDS]
> Description		= TDS driver (Sybase/MS SQL)
> Driver		= /usr/lib/odbc/libtdsodbc.so
> Setup			= /usr/lib/odbc/libtdsS.so
> CPTimeout		= 
> CPReuse		= 
> FileUsage		= 1
> 
> And in your odbc.ini file, use the 'FreeTDS' entry that you created in
> odbcinst.ini :
> 
> [mssql]
> Driver = FreeTDS
> Description = MS SQL running on monet
> Trace = No
> Servername = MONET
> Database = AfariaDB
> 
> On our Debian server, it did the trick...
> 
> -- Jean Baltus
> 
> 
> -----Original Message-----
> From: egenix-users-bounces at egenix.com
> [mailto:egenix-users-bounces at egenix.com] On Behalf Of Marcos Iuato
> Sent: mardi 10 octobre 2006 19:10
> To: egenix-users at egenix.com
> Subject: [egenix-users] Zope stops to respond
> 
> 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
> ###########################################
> 
> This message has been scanned by ICT - Africa Museum
> 
> ________________________________________
> 11/10/2006 - Filtered through antispam by ICT
>