From owner-freebsd-database Fri Jan 19 19:54:48 2001 Delivered-To: freebsd-database@freebsd.org Received: from mailout4-0.nyroc.rr.com (mailout4-0.nyroc.rr.com [24.92.226.120]) by hub.freebsd.org (Postfix) with ESMTP id 350CA37B401 for ; Fri, 19 Jan 2001 19:54:23 -0800 (PST) Received: from newdev (cm-24-29-63-39.nycap.rr.com [24.29.63.39]) by mailout4-0.nyroc.rr.com (8.11.2/RoadRunner 1.03) with SMTP id f0K3ogn26157 for ; Fri, 19 Jan 2001 22:50:42 -0500 (EST) Message-ID: <008901c0828d$47422250$273f1d18@newdev> From: "Sheridan Martin" To: Subject: Sybase, PHP, Apache, Win2000 Date: Fri, 19 Jan 2001 23:01:25 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0086_01C0826B.BF66C9B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG This is a multi-part message in MIME format. ------=_NextPart_000_0086_01C0826B.BF66C9B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.=20 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.=20 PowerDynamo is similar to Cold Fusion melding HTML and JavaScript to = provide connectivity to Sybase SQL Servrers.=20 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.=20 I first became interested in PHP when we attempted to move the existing = application to Laptop computers for purpose of taking to presentations.=20 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.=20 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.=20 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:=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 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.=20 I ran into problems the working the PHP4 build, Apache, and Sybase ASE.=20 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.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Apache, PHP4, MySQL, and IE5 work well in Win2000.=20 Sybase ASE is working and can be connected to by SQL Advantage, Access = and other tools using ODBC.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 On my home computer I get the following error message from Apache/PHP.=20 The instruction at "0x00a555b1" referenced memory at "0xa5ed7940".=20 The memory could not be "written".=20 Click on OK to terminate the program=20 Apache/1.3.14 Server at 127.0.0.1 Port 80=20 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.=20 PHP Version 4.0.5-dev=20 Windows NT 5.0 build 2195 / Jan 12 2001=20 Sybase 11.9.2 ASE for Windows NT=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 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=20 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.=20 Bottom Line = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Is there some place where I could receive assistance in PHP, APACHE, = SYBASE to work together in a Win2000 OS environment.=20 I would be willing to purchase a version of PHP that support Sybase in = the above configuration. sjm05@health.state.ny.us=20 I have details of the error message and supportive set-up information, = but this format does not support the presentation of such materials.=20 ------=_NextPart_000_0086_01C0826B.BF66C9B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I work for NYS Department of Health. We = have a=20 large Public Health Network which operates on SUN boxes with Sybase ASE = SQL.=20 Most of the applications are written in a combination of Perl, Java, = HTML,=20 Javascript.
 
My group is responcible for a major = application=20 that was developed to collect Labs information. This application is = written=20 largely in PowerDynamo, HTML, JavaScript, and Perl using an abundant = amount of=20 stored procedures.
 
PowerDynamo is similar to Cold Fusion = melding HTML=20 and JavaScript to provide connectivity to Sybase SQL Servrers. =
 
I am investigating the possibility of = replacing the=20 PowerDynamo with PHP. On the surface it appears that we would not be = facing a=20 major rewrite as we would if we were to employ JSP as an alternative.=20 PowerDynamo is a dead product in the eyes of Sybase as well as most of = the=20 Sybase Developer community.
 
I first became interested in PHP when = we attempted=20 to move the existing application to Laptop computers for purpose of = taking to=20 presentations.
 
I found that the combination of the MS = Personal Web=20 Server and PowerDynamo was very unstable. I began looking for a better = Web=20 Server for the Laptop computers which lead me to Apache. To date I have = never=20 been able to get PowerDynamo to work with the Apache Web Server. =
 
In learning about the Apache Web Server = I began to=20 seeing the PHP product being discussed as a SQL Server interface. So I = began=20 investigating PHP at that point.
 
So for I have PHP, MySQL, and Apache = functioning=20 properly in Win2000. Sybase is functioning properly as well in the ODBC=20 interface to SQLAdvantage, Access, PowerBuilder, etc. When I attempt to = connect=20 the PHP code to the Sybase server it fails giving the following error = message:=20
 

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
I put together a short piece of code = based on a the=20 Sybase sample that is posted on Thickbook.com site (http://www.thick= book.com/extra/php_sybase.phtml)=20 just to check the ability to connect the Apache Web Server through PHP = to a=20 Sybase ASE SQL Server in a Windows 2000 OS environment.
 
I ran into problems the working the = PHP4 build,=20 Apache, and Sybase ASE.
 
I had downloaded PHP4 from several = InterNet=20 locations and none have worked properly when connecting to Sybase ASE = through an=20 Apache Web Server in a Win2000 OS.
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
<?php
// create connection =
$connection =3D=20 sybase_connect("NEWDEV","sa","smile10")
or die("Couldn't make = connection.");=20
 
// select database
$db =3D=20 sybase_select_db("psdemodb", $connection)
or die("Couldn't select=20 database.");
 
// free resources and close connection=20
sybase_free_result($sql_result);
sybase_close($connection); =
?>=20
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
Apache, PHP4, MySQL, and IE5 work well = in Win2000.=20
 
Sybase ASE is working and can be = connected to by=20 SQL Advantage, Access and other tools using ODBC.
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
On my home computer I get the following = error=20 message from Apache/PHP.
 
The instruction at "0x00a555b1" = referenced memory=20 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=20
 
This has happened several times with = several builds=20 of the Apache, PHP, and reloading fresh installs of the Win 2000 OS just = to be=20 sure.
 
PHP Version 4.0.5-dev
Windows NT = 5.0 build 2195=20 / Jan 12 2001
 
Sybase 11.9.2 ASE for Windows NT =
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
At work it sometimes writes the = following error to=20 the Apache error.log:
 
[Thu Jan 18 21:39:32 2001] [error] = [client=20 127.0.0.1] Premature end of script headers: c:/php4/php.exe =
 
As soon as I comment out the = sybase_connect() line=20 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=20 scripting is not the problem.
 

Bottom Line=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 
Is there some place where I could = receive=20 assistance in PHP, APACHE, SYBASE to work together in a Win2000 OS = environment.=20
I would be willing to purchase a version of PHP that support Sybase = in the=20 above configuration. sjm05@health.state.ny.us=20
 
I have details of the error message and = supportive=20 set-up information, but this format does not support the presentation of = such=20 materials.
 
 
------=_NextPart_000_0086_01C0826B.BF66C9B0-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message