[Zope-DB] Connect Zope to MS-SQL

Marcos Iuato marcos at hiper.com.br
Thu Aug 5 16:19:54 EDT 2004


I 'm trying to connect zope on linux to MS-SQL Server using
Freetds + UnixODBC + SQLRelay from debian testing 

also tryed:
Freetds + UnixODBC + SQLRelay from debian stable 

This works but is very unstable, a stored procedure sometimes is ok, 
sometimes happens a rollback and sometimes commit but returns no results. 

Has anyone using an open sorce solution to connect zope on linux to MS-SQL 
Server? or everybody is using mxODBC Zope DA? 

Well, i will attach a log file of SQLRelay, any help will be appreciated. 

Regards,
Marcos Iuato 

-------------- next part --------------
connection : getting unix socket...

connection :    opening /var/cache/sqlrelay/tmp/sockseq

connection :    locking...

connection :    got sequence number: 1

connection :    writing new sequence number: 2

connection :    unlocking...

connection : done getting unix socket

08/05/2004 13:37:13 BRT connection [5969] : logging in...

08/05/2004 13:37:16 BRT connection [5969] : done logging in

08/05/2004 13:37:16 BRT connection [5969] : setting autocommit...

08/05/2004 13:37:16 BRT connection [5969] : done setting autocommit

08/05/2004 13:37:16 BRT connection [5969] : initializing cursors...

08/05/2004 13:37:16 BRT connection [5969] :     0

08/05/2004 13:37:16 BRT connection [5969] :     1

08/05/2004 13:37:16 BRT connection [5969] :     2

08/05/2004 13:37:16 BRT connection [5969] :     3

08/05/2004 13:37:16 BRT connection [5969] :     4

08/05/2004 13:37:16 BRT connection [5969] : done initializing cursors

connection : attaching to shared memory and semaphores

connection : id filename: 

connection : /var/cache/sqlrelay/tmp/sqlrodbcguarulhos

connection :    attaching to shared memory...

connection :    attaching to semaphores...

connection : done attaching to shared memory and semaphores

connection : incrementing connection count...

connection :    2

connection : done incrementing connection count

connection :                creating /var/cache/sqlrelay/tmp/sqlrodbcguarulhos-msguarulhos

08/05/2004 13:37:16 BRT connection [5969] : listening on sockets...

08/05/2004 13:37:16 BRT connection [5969] :     listening on unix socket: /var/cache/sqlrelay/tmp/1

08/05/2004 13:37:16 BRT connection [5969] :     listening on inet socket: 0

08/05/2004 13:37:16 BRT connection [5969] : done listening on sockets

08/05/2004 13:37:16 BRT connection [5969] : waiting for available database...

connection : database is available

08/05/2004 13:37:16 BRT connection [5969] : database is available

08/05/2004 13:37:16 BRT connection [5969] : initializing session...

08/05/2004 13:37:16 BRT connection [5969] : done initializing session...

connection : announcing availability...

connection :    handoff=reconnect

connection : done announcing availability...

08/05/2004 13:37:22 BRT connection [5969] : waiting for client...

08/05/2004 13:37:22 BRT connection [5969] :     reconnect succeeded

08/05/2004 13:37:22 BRT connection [5969] : done waiting for client

08/05/2004 13:37:22 BRT connection [5969] : client session...

08/05/2004 13:37:22 BRT connection [5969] :         getting command...

08/05/2004 13:37:22 BRT connection [5969] :         done getting command

08/05/2004 13:37:22 BRT connection [5969] :     authenticate

08/05/2004 13:37:22 BRT connection [5969] :     authenticate...

08/05/2004 13:37:22 BRT connection [5969] :     authentication was done on listener

08/05/2004 13:37:22 BRT connection [5969] :         getting command...

08/05/2004 13:37:22 BRT connection [5969] :         done getting command

08/05/2004 13:37:22 BRT connection [5969] :     new query

08/05/2004 13:37:22 BRT connection [5969] :             0

08/05/2004 13:37:22 BRT connection [5969] :         found a free cursor...

08/05/2004 13:37:22 BRT connection [5969] :         done getting a cursor

08/05/2004 13:37:22 BRT connection [5969] :     handling query...

08/05/2004 13:37:22 BRT connection [5969] :         getting query...

08/05/2004 13:37:22 BRT connection [5969] :             querylength:

08/05/2004 13:37:22 BRT connection [5969] :                 21

08/05/2004 13:37:22 BRT connection [5969] :             query:

08/05/2004 13:37:22 BRT connection [5969] : Pr_Sel_ReqResp 1, 'P'

08/05/2004 13:37:22 BRT connection [5969] :         getting query succeeded

08/05/2004 13:37:22 BRT connection [5969] :         getting input binds...

08/05/2004 13:37:22 BRT connection [5969] :         done getting input binds

08/05/2004 13:37:22 BRT connection [5969] :         getting output binds...

08/05/2004 13:37:22 BRT connection [5969] :         done getting output binds

08/05/2004 13:37:22 BRT connection [5969] :         getting send column info...

08/05/2004 13:37:22 BRT connection [5969] :             send column info

08/05/2004 13:37:22 BRT connection [5969] :         done getting send column info...

08/05/2004 13:37:22 BRT connection [5969] :         processing query...

08/05/2004 13:37:22 BRT connection [5969] :             preparing/executing...

08/05/2004 13:37:23 BRT connection [5969] :         commit or rollback check...

08/05/2004 13:37:23 BRT connection [5969] :             commit or rollback needed

08/05/2004 13:37:23 BRT connection [5969] :         done with commit or rollback check

08/05/2004 13:37:23 BRT connection [5969] :         processing query succeeded

08/05/2004 13:37:23 BRT connection [5969] :         done processing query

08/05/2004 13:37:23 BRT connection [5969] :         returning result set header...

08/05/2004 13:37:23 BRT connection [5969] :             returning row counts...

08/05/2004 13:37:23 BRT connection [5969] :         sending row counts...

08/05/2004 13:37:23 BRT connection [5969] :             actual rows unknown

08/05/2004 13:37:23 BRT connection [5969] :             affected rows: 0

08/05/2004 13:37:23 BRT connection [5969] :         done sending row counts

08/05/2004 13:37:23 BRT connection [5969] :             done returning row counts

08/05/2004 13:37:23 BRT connection [5969] :             column info will be sent

08/05/2004 13:37:23 BRT connection [5969] :             returning column counts...

08/05/2004 13:37:23 BRT connection [5969] :         sending column count...

08/05/2004 13:37:23 BRT connection [5969] :             21

08/05/2004 13:37:23 BRT connection [5969] :         done sending column count

08/05/2004 13:37:23 BRT connection [5969] :             done returning column counts

08/05/2004 13:37:23 BRT connection [5969] :             returning column info...

08/05/2004 13:37:23 BRT connection [5969] :         sending column type format...

08/05/2004 13:37:23 BRT connection [5969] :             id's

08/05/2004 13:37:23 BRT connection [5969] :         done sending column type format

08/05/2004 13:37:23 BRT connection [5969] :             nr_CD_RESPONSAVEL:28:8 (0,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_NM_RESPONSAVEL:17:60 (60,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_NACIONALIDADE:17:20 (20,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_NATURALIDADE:17:40 (40,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_UF:17:2 (2,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             nr_CTPS:28:8 (0,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             nr_SERIE_CTPS:17:5 (5,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_UF_CTPS:17:2 (2,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_REPARTICAO:17:20 (20,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             dt_LICENCIATURA:0:4 (30,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_TITULO_HABILITACAO:17:15 (15,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_EMAIL:17:60 (60,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             dt_INSCRICAO:0:4 (30,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_NR_CPFCNPJ:17:14 (14,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_RG:17:15 (15,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_DS_RGDV:17:3 (3,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             dt_NASCIMENTO:0:4 (30,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             tx_ST_ATIVIDADE:17:1 (1,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             dt_INICIO_SUSPENSAO:0:4 (30,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             dt_FINAL_SUSPENSAO:0:4 (30,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             nr_INSC_MUNICIPAL:56:4 (0,0) NOT NULL 

08/05/2004 13:37:23 BRT connection [5969] :             done returning column info

08/05/2004 13:37:23 BRT connection [5969] :         returning output bind values

08/05/2004 13:37:23 BRT connection [5969] :             0

08/05/2004 13:37:23 BRT connection [5969] :         done returning output bind values

08/05/2004 13:37:23 BRT connection [5969] :         done returning result set header

08/05/2004 13:37:23 BRT connection [5969] :     handle query succeeded

08/05/2004 13:37:23 BRT connection [5969] :         returning result set data...

08/05/2004 13:37:23 BRT connection [5969] :         skipping 0 rows...

08/05/2004 13:37:23 BRT connection [5969] :         done skipping rows

08/05/2004 13:37:23 BRT connection [5969] :         fetching 0 rows...

08/05/2004 13:37:23 BRT connection [5969] :             "1","PRISMA ENGENHARIA E TOPOGRAFIA","                    "," ","  ",NULL"0    ","  ","                    ",NULL"               ","prismatopografia at ul.com.br","2002-08-12 00:00:00","              ",NULLNULLNULL"A",NULLNULLNULL

08/05/2004 13:37:23 BRT connection [5969] :         done returning result set data

08/05/2004 13:37:23 BRT connection [5969] :         getting command...

08/05/2004 13:37:23 BRT connection [5969] :         done getting command

08/05/2004 13:37:23 BRT connection [5969] :     commit

08/05/2004 13:37:23 BRT connection [5969] :         getting command...

08/05/2004 13:37:23 BRT connection [5969] :         done getting command

08/05/2004 13:37:23 BRT connection [5969] :     end session

08/05/2004 13:37:23 BRT connection [5969] :         ending session...

08/05/2004 13:37:23 BRT connection [5969] :         aborting all busy cursors...

08/05/2004 13:37:23 BRT connection [5969] :         done aborting all busy cursors

08/05/2004 13:37:23 BRT connection [5969] :         resetting autocommit behavior...

08/05/2004 13:37:23 BRT connection [5969] :             setting autocommit on...

08/05/2004 13:37:23 BRT connection [5969] :             done setting autocommit on...

08/05/2004 13:37:23 BRT connection [5969] :         done resetting autocommit behavior...

08/05/2004 13:37:23 BRT connection [5969] :     done ending session

08/05/2004 13:37:23 BRT connection [5969] :     waiting for client to close the connection...

08/05/2004 13:37:23 BRT connection [5969] :     done waiting for client to close the connection...

08/05/2004 13:37:23 BRT connection [5969] : done with client session

connection : decrementing session count...

connection :    0

connection : done decrementing session count

08/05/2004 13:37:23 BRT connection [5969] : waiting for available database...

connection : database is available

08/05/2004 13:37:23 BRT connection [5969] : database is available

08/05/2004 13:37:23 BRT connection [5969] : initializing session...

08/05/2004 13:37:23 BRT connection [5969] : done initializing session...

connection : announcing availability...

connection :    handoff=reconnect

connection : done announcing availability...

08/05/2004 13:43:56 BRT connection [5969] : waiting for client...

08/05/2004 13:43:56 BRT connection [5969] :     reconnect succeeded

08/05/2004 13:43:56 BRT connection [5969] : done waiting for client

08/05/2004 13:43:56 BRT connection [5969] : client session...

08/05/2004 13:43:56 BRT connection [5969] :         getting command...

08/05/2004 13:43:56 BRT connection [5969] :         done getting command

08/05/2004 13:43:56 BRT connection [5969] :     authenticate

08/05/2004 13:43:56 BRT connection [5969] :     authenticate...

08/05/2004 13:43:56 BRT connection [5969] :     authentication was done on listener

08/05/2004 13:43:56 BRT connection [5969] :         getting command...

08/05/2004 13:43:56 BRT connection [5969] :         done getting command

08/05/2004 13:43:56 BRT connection [5969] :     new query

08/05/2004 13:43:56 BRT connection [5969] :             0

08/05/2004 13:43:56 BRT connection [5969] :         found a free cursor...

08/05/2004 13:43:56 BRT connection [5969] :         done getting a cursor

08/05/2004 13:43:56 BRT connection [5969] :     handling query...

08/05/2004 13:43:56 BRT connection [5969] :         getting query...

08/05/2004 13:43:56 BRT connection [5969] :             querylength:

08/05/2004 13:43:56 BRT connection [5969] :                 21

08/05/2004 13:43:56 BRT connection [5969] :             query:

08/05/2004 13:43:56 BRT connection [5969] : Pr_Sel_ReqResp 9, 'P'

08/05/2004 13:43:56 BRT connection [5969] :         getting query succeeded

08/05/2004 13:43:56 BRT connection [5969] :         getting input binds...

08/05/2004 13:43:56 BRT connection [5969] :         done getting input binds

08/05/2004 13:43:56 BRT connection [5969] :         getting output binds...

08/05/2004 13:43:56 BRT connection [5969] :         done getting output binds

08/05/2004 13:43:56 BRT connection [5969] :         getting send column info...

08/05/2004 13:43:56 BRT connection [5969] :             send column info

08/05/2004 13:43:56 BRT connection [5969] :         done getting send column info...

08/05/2004 13:43:56 BRT connection [5969] :         processing query...

08/05/2004 13:43:56 BRT connection [5969] :             preparing/executing...

08/05/2004 13:43:56 BRT connection [5969] :         commit or rollback check...

08/05/2004 13:43:56 BRT connection [5969] :             commit or rollback needed

08/05/2004 13:43:56 BRT connection [5969] :         done with commit or rollback check

08/05/2004 13:43:56 BRT connection [5969] :         processing query succeeded

08/05/2004 13:43:56 BRT connection [5969] :         done processing query

08/05/2004 13:43:56 BRT connection [5969] :         returning result set header...

08/05/2004 13:43:56 BRT connection [5969] :             returning row counts...

08/05/2004 13:43:56 BRT connection [5969] :         sending row counts...

08/05/2004 13:43:56 BRT connection [5969] :             actual rows unknown

08/05/2004 13:43:56 BRT connection [5969] :             affected rows: 0

08/05/2004 13:43:56 BRT connection [5969] :         done sending row counts

08/05/2004 13:43:56 BRT connection [5969] :             done returning row counts

08/05/2004 13:43:56 BRT connection [5969] :             column info will be sent

08/05/2004 13:43:56 BRT connection [5969] :             returning column counts...

08/05/2004 13:43:56 BRT connection [5969] :         sending column count...

08/05/2004 13:43:56 BRT connection [5969] :             0

08/05/2004 13:43:56 BRT connection [5969] :         done sending column count

08/05/2004 13:43:56 BRT connection [5969] :             done returning column counts

08/05/2004 13:43:56 BRT connection [5969] :             returning column info...

08/05/2004 13:43:56 BRT connection [5969] :         sending column type format...

08/05/2004 13:43:56 BRT connection [5969] :             id's

08/05/2004 13:43:56 BRT connection [5969] :         done sending column type format

08/05/2004 13:43:56 BRT connection [5969] :             done returning column info

08/05/2004 13:43:56 BRT connection [5969] :         returning output bind values

08/05/2004 13:43:56 BRT connection [5969] :             0

08/05/2004 13:43:56 BRT connection [5969] :         done returning output bind values

08/05/2004 13:43:56 BRT connection [5969] :         done returning result set header

08/05/2004 13:43:56 BRT connection [5969] :     handle query succeeded

08/05/2004 13:43:56 BRT connection [5969] :         returning result set data...

08/05/2004 13:43:56 BRT connection [5969] :         done returning result set data

08/05/2004 13:43:56 BRT connection [5969] :         getting command...

08/05/2004 13:43:56 BRT connection [5969] :         done getting command

08/05/2004 13:43:56 BRT connection [5969] :     commit

08/05/2004 13:43:58 BRT connection [5969] :         getting command...

08/05/2004 13:43:58 BRT connection [5969] :         done getting command

08/05/2004 13:43:58 BRT connection [5969] :     end session

08/05/2004 13:43:58 BRT connection [5969] :         ending session...

08/05/2004 13:43:58 BRT connection [5969] :         aborting all busy cursors...

08/05/2004 13:43:58 BRT connection [5969] :         done aborting all busy cursors

08/05/2004 13:43:58 BRT connection [5969] :         resetting autocommit behavior...

08/05/2004 13:43:58 BRT connection [5969] :             setting autocommit on...

08/05/2004 13:43:58 BRT connection [5969] :             done setting autocommit on...

08/05/2004 13:43:58 BRT connection [5969] :         done resetting autocommit behavior...

08/05/2004 13:43:58 BRT connection [5969] :     done ending session

08/05/2004 13:43:58 BRT connection [5969] :     waiting for client to close the connection...

08/05/2004 13:43:58 BRT connection [5969] :     done waiting for client to close the connection...

08/05/2004 13:43:58 BRT connection [5969] : done with client session

connection : decrementing session count...

connection :    0

connection : done decrementing session count

08/05/2004 13:43:58 BRT connection [5969] : waiting for available database...

connection : database is available

08/05/2004 13:43:58 BRT connection [5969] : database is available

08/05/2004 13:43:58 BRT connection [5969] : initializing session...

08/05/2004 13:43:58 BRT connection [5969] : done initializing session...

connection : announcing availability...



More information about the Zope-DB mailing list