Date: Fri, 19 Jan 2001 23:01:25 -0400 From: "Sheridan Martin" <sjm05@nycap.rr.com> To: <freebsd-database@FreeBSD.ORG> Subject: Sybase, PHP, Apache, Win2000 Message-ID: <008901c0828d$47422250$273f1d18@newdev>
next in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] 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. My group is responcible for a major application that was developed to collect Labs information. This application is written largely in PowerDynamo, HTML, JavaScript, and Perl using an abundant amount of stored procedures. PowerDynamo is similar to Cold Fusion melding HTML and JavaScript to provide connectivity to Sybase SQL Servrers. I am investigating the possibility of replacing the PowerDynamo with PHP. On the surface it appears that we would not be facing 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 in PHP 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. To date 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 seeing the PHP product being discussed as a SQL Server interface. So I began investigating PHP at that point. So for I have PHP, MySQL, and Apache functioning properly in Win2000. Sybase is functioning properly as well in the ODBC interface to SQLAdvantage, Access, PowerBuilder, etc. When I attempt to connect the PHP code to the Sybase server it fails giving the following error message: ====================================== I put together a short piece of code based on a the Sybase sample that is posted on Thickbook.com site (http://www.thickbook.com/extra/php_sybase.phtml) just to check the ability to connect the Apache Web Server through PHP to a Sybase ASE SQL Server in a Windows 2000 OS environment. I ran into problems the working the PHP4 build, Apache, and Sybase ASE. I had downloaded PHP4 from several InterNet locations and none have worked properly when connecting to Sybase ASE through an Apache Web Server in a Win2000 OS. =========================================== <?php // create connection $connection = sybase_connect("NEWDEV","sa","smile10") or die("Couldn't make connection."); // select database $db = sybase_select_db("psdemodb", $connection) or die("Couldn't select database."); // free resources and close connection sybase_free_result($sql_result); sybase_close($connection); ?> ======================================= Apache, PHP4, MySQL, and IE5 work well in Win2000. Sybase ASE is working and can be connected to by SQL Advantage, Access and other tools using ODBC. ======================================== On my home computer I get the following error message from Apache/PHP. 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 several times with several builds of the Apache, PHP, and reloading fresh installs of 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 ======================================== At work it sometimes writes the following error to the Apache error.log: [Thu Jan 18 21:39:32 2001] [error] [client 127.0.0.1] Premature end of script headers: c:/php4/php.exe As soon as I comment out the sybase_connect() line the rest of the script executes properly although the other sybase calls generate error messages due to the fact that a connection does not exist. So the scripting is not the problem. Bottom Line ========================================= Is there some place where I could receive assistance in PHP, APACHE, SYBASE to work together in a Win2000 OS environment. I would be willing to purchase a version of PHP that support Sybase in the above configuration. sjm05@health.state.ny.us I have details of the error message and supportive set-up information, but this format does not support the presentation of such materials. [-- Attachment #2 --] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type> <META content="MSHTML 5.00.2920.0" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>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. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>My group is responcible for a major application that was developed to collect Labs information. This application is written largely in PowerDynamo, HTML, JavaScript, and Perl using an abundant amount of stored procedures. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>PowerDynamo is similar to Cold Fusion melding HTML and JavaScript to provide connectivity to Sybase SQL Servrers. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I am investigating the possibility of replacing the PowerDynamo with PHP. On the surface it appears that we would not be facing 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. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I first became interested in PHP when we attempted to move the existing application to Laptop computers for purpose of taking to presentations. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>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. To date I have never been able to get PowerDynamo to work with the Apache Web Server. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>In learning about the Apache Web Server I began to seeing the PHP product being discussed as a SQL Server interface. So I began investigating PHP at that point. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>So for I have PHP, MySQL, and Apache functioning properly in Win2000. Sybase is functioning properly as well in the ODBC interface to SQLAdvantage, Access, PowerBuilder, etc. When I attempt to connect the PHP code to the Sybase server it fails giving the following error message: </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2><BR>====================================== </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I put together a short piece of code based on a the Sybase sample that is posted on Thickbook.com site (<A href="http://www.thickbook.com/extra/php_sybase.phtml">http://www.thickbook.com/extra/php_sybase.phtml</A>) just to check the ability to connect the Apache Web Server through PHP to a Sybase ASE SQL Server in a Windows 2000 OS environment. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I ran into problems the working the PHP4 build, Apache, and Sybase ASE. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I had downloaded PHP4 from several InterNet locations and none have worked properly when connecting to Sybase ASE through an Apache Web Server in a Win2000 OS. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>=========================================== </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2><?php <BR>// create connection <BR>$connection = sybase_connect("NEWDEV","sa","smile10") <BR>or die("Couldn't make connection."); </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>// select database <BR>$db = sybase_select_db("psdemodb", $connection) <BR>or die("Couldn't select database."); </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>// free resources and close connection <BR>sybase_free_result($sql_result); <BR>sybase_close($connection); <BR>?> </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>======================================= </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Apache, PHP4, MySQL, and IE5 work well in Win2000. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Sybase ASE is working and can be connected to by SQL Advantage, Access and other tools using ODBC. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>======================================== </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>On my home computer I get the following error message from Apache/PHP. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>The instruction at "0x00a555b1" referenced memory at "0xa5ed7940". <BR>The memory could not be "written". </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Click on OK to terminate the program </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Apache/1.3.14 Server at 127.0.0.1 Port 80 </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>This has happened several times with several builds of the Apache, PHP, and reloading fresh installs of the Win 2000 OS just to be sure. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>PHP Version 4.0.5-dev <BR>Windows NT 5.0 build 2195 / Jan 12 2001 </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Sybase 11.9.2 ASE for Windows NT </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>======================================== </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>At work it sometimes writes the following error to the Apache error.log: </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>[Thu Jan 18 21:39:32 2001] [error] [client 127.0.0.1] Premature end of script headers: c:/php4/php.exe </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>As soon as I comment out the sybase_connect() line the rest of the script executes properly although the other sybase calls generate error messages due to the fact that a connection does not exist. So the scripting is not the problem. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2><BR>Bottom Line ========================================= </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Is there some place where I could receive assistance in PHP, APACHE, SYBASE to work together in a Win2000 OS environment. <BR>I would be willing to purchase a version of PHP that support Sybase in the above configuration. <A href="mailto:sjm05@health.state.ny.us">sjm05@health.state.ny.us</A> </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I have details of the error message and supportive set-up information, but this format does not support the presentation of such materials. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?008901c0828d$47422250$273f1d18>