Skip to Content.
Sympa Menu

freetds - AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "roland bole" <roland.bole AT gmx.at>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: AW: [freetds] connect problem to mssql 7.0
  • Date: Tue, 9 Dec 2003 12:58:11 +0100




>
> Thanks for your reply.
>
> I changed the freetds.conf file to get the following dump
>
> pid: 11842:2003-12-09 11:16:32 processing row. column size is 11
> pid: 11842:2003-12-09 11:16:32 clearing column 0 NULL bit
> pid: 11842:2003-12-09 11:16:32 leaving dbnextrow() returning -1
> pid: 11842:2003-12-09 11:16:32 dbdatlen() type = 39
> pid: 11842:2003-12-09 11:16:32 leaving dbdatlen() returning 11
> pid: 11842:2003-12-09 11:16:32 dbdatlen() type = 39
> pid: 11842:2003-12-09 11:16:32 leaving dbdatlen() returning 11
> pid: 11842:2003-12-09 11:16:32 inside dbnextrow()
> pid: 11842:2003-12-09 11:16:32 processing row tokens. marker is fd
> pid: 11842:2003-12-09 11:16:32 leaving dbnextrow() returning -2
> pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsetlogintime()
> pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsettime()
> pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsetmaxprocs()
> -- old PID
> -- new PID
> pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsetlogintime()
> pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsettime()
> pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsetmaxprocs()
> pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsetlogintime()
> pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsettime()
> pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsetmaxprocs()
> pid: 11846:Sending packet @ 2003-12-09 11:16:49
> 0000 01 01 00 18 00 00 01 00 75 00 73 00 65 00 20 00
> |........u .s.e. .|
> 0010 45 00 4c 00 42 00 45 00 |E.L.B.E.|
>
>
> pid: 11846:TDS: Write failed in tds_write_packet
> Error: 104 (Connection reset by peer)
> pid: 11846:2003-12-09 11:16:49 inside
> tds_process_default_tokens() marker is 0
> pid: 11846:2003-12-09 11:16:49 leaving
> tds_process_default_tokens() connection dead
> pid: 11846:2003-12-09 11:16:49 inside
> tds_process_default_tokens() marker is 0
> pid: 11846:2003-12-09 11:16:49 leaving
> tds_process_default_tokens() connection dead
> pid: 11846:2003-12-09 11:16:49 inside
> tds_process_default_tokens() marker is 0
> pid: 11846:2003-12-09 11:16:49 leaving
> tds_process_default_tokens() connection dead
> pid: 11846:2003-12-09 11:16:49 inside
> tds_process_default_tokens() marker is 0
> pid: 11846:2003-12-09 11:16:49 leaving
> tds_process_default_tokens() connection dead
>
>
> you are right, the problem is that apache use a new PID and
> the result is that freetds can not work with this new connect.
>
> I don't know why apache change the PID.
>
> Ok we have the error, what can I do to solve this problem ?
>
> Roland
>

>Apache 1.3 should change PID simply cause after some request it stop sub
>process and fork another apache... This to keep itself stable. However I
>don't understand why PHP do not make another connection...
I use mssql_pconnect to connect, php should establish a new connection

>When first process finish connections are automatically closed... or not ??
How can I assert this?


>Perhaps it's a PHP problem? You spotted a very strange problem...
I use the mssql PHP Functions according the php manual
There are only simple queries with joins.

Perhaps there is a problem with environment variables I didnĀ“t set one.


Roland


>freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page