FreeTDS Development Group

[Rasmus Lerdorf <rasmus AT php.net>]

Anybody here have any idea on this one?  Would be very nice if we could
give this guy a hand.

Sorry for the cc to freetds list, but I figured someone there might have a
clue.

-Rasmus

---------- Forwarded message ----------
Date: 19 Jan 2001 17:40:02 -0000
From: sjm05 AT health.state.ny.us
To: php-dev AT lists.php.net
Subject: [PHP-DEV] PHP 4.0 Bug #8808: sybase_connect() problem

From:             sjm05 AT health.state.ny.us
Operating system: Win2000
PHP version:      4.0.4pl1
PHP Bug Type:     Sybase-ct (ctlib) related
Bug description:  sybase_connect() problem

I work for NYS Department of Health.  We have a large
Public Health Network which operates on SUN boxes with Sybase ASE SQL. Most 
of the applications are written
in a combination of Perl, Java, HTML, Javascript.

I work in an area where a major application was developed to collect Labs 
information.  The application is written largely in PowerDynamo, HTML, 
JavaScript, and Perl using an abundant amount of stored procedures.

I am investigating the possibility of replacing the PowerDynamo with PHP.  On 
the surface it appears that we would not be in for a major rewrite as we 
would if we were to employ JSP as an alternative.  PowerDynamo is a dead
product in the eyes of Sybase as well as most of the Sybase Developer 
community.

I first became interested when we attempted to move the existing application 
to Laptop computers for purpose of taking to presentations.  I found that the 
combination of the MS Personal Web Server and PowerDynamo was very
unstable.  I began looking for a better Web Server for the Laptop computers 
which lead me to Apache.  I have never been able to get PowerDynamo to work 
with the Apache Web Server.

In learning about the Apache Web Server I began to see the PHP product being 
discussed as a SQL Server interface.  So I began investigating it at that 
point.

So for I have PHP, MySQL, and Apache functioning properly in Win2000.

Sybase ASE is functioning properly as well in the ODBC interface to SQL 
Advantage, Access, PowerBuilder, etc.

When I attempt to connect the PHP code to the Sybase server it fails giving 
the following error message:

========================
The instruction at "0x00a555b1" referenced memory at "0xa5ed7940".

The memory could not be "written".

Click on OK to terminate the program

Apache/1.3.14 Server at 127.0.0.1 Port 80

This has happened a number of times with several builds of the Apache, PHP, 
and reloading the Win 2000 OS just to be sure.

PHP Version 4.0.5-dev
Windows NT 5.0 build 2195 / Jan 12 2001

Sybase 11.9.2 ASE for Windows NT

I have installed PHP on other computers using the same configurations and 
gotten some slightly different results.
As in what follows:

[Thu Jan 18 21:39:32 2001] [error] [client 127.0.0.1] Premature end of script 
headers: c:/php4/php.exe

In each case the call to the sybase_connect() causes PHP to fail.

If I comment out the sybase_connect() call the rest of the program runs 
although calls to other sybase functions return appropriate error messages in 
that there is no connection.

I can send more detailed information in the way of Apache error.log, php.ini, 
phpinfo() display screen, and the Apache httpd.conf.  This format does not 
lead itself to attachments.


I may have left something out in the way of preparing the interface in that I 
have found very little reference to the PHP / Sybase installation.



-- 
Edit Bug report at: http://bugs.php.net/?id=8808&edit=1



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe AT lists.php.net
For additional commands, e-mail: php-dev-help AT lists.php.net
To contact the list administrators, e-mail: php-list-admin AT lists.php.net