To All,
Could anybody help me with my problem related to php4 with Sybase?
The system concerned is running SuSE 7.1 Professional
The installed package of SuSE with apache and php4 works fantastic. The
SuSE version of php4 includes many of the goodies (more than I need except
one). Using the source package for php4 on the same SuSE distro CD and
compiling the package using;
rpm -bb /usr/src/packages/SPECS/mod_php4.spec
is successful and works fine.....as it should.
However the trouble comes when I add the "--with-sybase-ct=/opt/sybase into
the mix. Sybase 11.0.3 is installed in /opt/sybase. I can connect with the
Sybase server with no problem using Sybase's isql client, and retrieve data
in good time.
When accessing data from the Sybase database through apache/php4 I get;
"[notice] child pid 15988 exit signal Segmentation fault (11)"
in the error_log.
I have made a page that accesses a mysql database to fill in one table and
another to access a Sybase database. The mysql page does not complain where
the Sybase page provides the above error.
The Sybase code is as follows;
$sybase_link = sybase_connect("PCS", "apache", "apache");
sybase_select_db("pcs1prod", $sybase_link);
$query = "SELECT last_name, first_name, encrypt_flag ";
$query .= "FROM User_Table ";
$sybase_result = sybase_query($query, $sybase_link);
$rowcount = 0;
print("<table>");
while($row = sybase_fetch_row($sybase_result))
{
$rowcount += 1;
$last_name = trim($row[0]);
$first_name = trim($row[1]);
$encrypt_flag = trim($row[2]);
print("<tr><td>$rowcount</td><td>$last_name</td><td>$first_name</td><td>$enc
rypt_flag</td></tr>");
}
print("</table>");
sybase_close($sybase_link);
Reporting errors to the web page I get;
Warning: Sybase: Server message: Changed database context to 'pcs1prod'.
(severity 10, procedure N/A) in /pcs/pk.php on line 10
(where line 10 is actually the first line shown here - "sybase_connect")
Data does come back however after a long period.
Does anybody have any clues I might look for?
I appreciate any help here from anybody.
- Paul K
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
