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.