Re: [freetds] Rép. : [freetds] Re: update query with Freetds
Vincent Apesa
vapesa at hotmail.com
Wed Sep 6 09:53:28 EDT 2000
Hello,
I noticed in this example PHP is not loaded as a DSO in apache. Has anyone had any success using it as a DSO with freetds. I haven't been able to get it to work.
Vince
----- Original Message -----
From: Laurent DAVID
To: TDS Development Group
Sent: Wednesday, September 06, 2000 8:15 AM
Subject: [freetds] Rép. : [freetds] Re: update query with Freetds
Hello,
No, the update queries are quite short (less thant 100 characters).
The exact feature is :
- the update is done into the database
- the apache process gets a segmentation error logged into
error_log, and then traps, which causes the browser to get
no response from the apache server.
Furthermore, here are the installation steps we've followed :
1. Freetds compilation :
./configure --prefix=/usr/local/freetds/ --enable-msdblib --with-tdsver=4.2
2. PHP3 compilation
./configure '--with-apache=../apache_1.3.12' '--with-gd' '--with-ttf' '--with-xml' '--with-zlib' '--with-sybase=/usr/local/freetds/' '--enable-track-vars'
3-Apache installation
./configure --prefix=/usr/local/apache/ --activate-module=src/modules/php3/libphp3.a
And then modify the interfaces file of freetds to point to our database server.
Does anybody have an idea ?
Regards
>>> roger at firedrake.org 06/09/2000 13:20:41 >>>
On or about Wed, Sep 06, 2000 at 07:10:42AM +0000, L. DAVID typed:
>Hello,
>
>I'm a newbie into this community, and currently working
>on a project trying to use freetds 4.2 with PHP 3 running
>on Solaris with Apahce, to send some queries to a MS SQL 7 database
>running on NT.
>
>All the select like requests are running well, but
>Apache seems to trap when we are trying an update
>request on a table.
>
>Is this a bug, or is there something special to configure
>when building freetds ?
I'm also a newbie here... but this may be something that bit me,
which I've semi-solved. (There are archive messages that seem
to be related, though it's not entirely clear to me yet; and alas,
my employers disapprove of my spending the _entire_ day reading
about tools rather than working with them.)
Are the update queries longer than 512 characters, while the
selects are shorter? MS-SQL 7 seems to have problems with queries
sent in more than about two packets, and closes the data stream -
and FreeTDS hangs waiting for a response.
Try extending the packet length in write.c, where it's set to
512 at the moment - might also be worth raising BUFSIZ to match.
Something I haven't seen discussed here is spurious NULs - I'm
using DBD::Sybase on top of FreeTDS to talk to MS-SQL7, and
most of the fields returned by SELECTs have trailing NULs.
Naturally this wouldn't be a problem with C, but Perl quite
happily retains and forwards the NULs, thus confusing the web
browser... has anyone else seen this, and is there a
recommended fix?
Roger
--
Roger Burton West roger at firedrake.org
ACTING IN A PRIVATE CAPACITY
Senior Internet Developer Torrington Interactive
---
You are currently subscribed to freetds as: [ ldavid at tf1.fr]
To unsubscribe, forward this message to $subst('Email.Unsub')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20000906/24d94686/attachment.html
More information about the FreeTDS
mailing list