[egenix-users] Zope stops to respond

[BALTUS Jean]

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