sledneck
asked on
Suggestions for a php/sybase sql server
I want to write a web interface for a Sybase DB running on a Netware 6.5 server. The database was set up when I installed Zenworks, and it hold workstation inventory. I have installed and used XAMPP before. I would really like to be able to write the interface using my current server setup, and from what I've seen on the web, it is possible to enable the sybase extensions for PHP, but I have not been able to get it to work.
Let me say that I know nothing about Linux, so please don't offer Linux solutions. The details of my current setup are:
Database:
Sybase ASA 8.0.2
running on Netware 6.5 SP6
Database is part of Zenworks (it holds workstation inventory)
Web Server:
Apache2
PHP5
MySql
Perl
Running these as part of XAMPP package on a Windows XP box.
The current setup works fine if I build a database in the MySQL DB on the localhost and access it from php webpages. I want to be able to do the same thing for a remote Sybase DB.
So, can anyone suggest either a way to configure my current setup (preferred) or build a new one (Windows-based) so I can do this? Also, at us.php.net they mention that to enable sybase commands in PHP I need to add '--with-sybase-ct' to the php configuration. I don't know where this line should go, I haven't found any configuration files for PHP except PHP.ini, and its not in there.
Thanks.
Let me say that I know nothing about Linux, so please don't offer Linux solutions. The details of my current setup are:
Database:
Sybase ASA 8.0.2
running on Netware 6.5 SP6
Database is part of Zenworks (it holds workstation inventory)
Web Server:
Apache2
PHP5
MySql
Perl
Running these as part of XAMPP package on a Windows XP box.
The current setup works fine if I build a database in the MySQL DB on the localhost and access it from php webpages. I want to be able to do the same thing for a remote Sybase DB.
So, can anyone suggest either a way to configure my current setup (preferred) or build a new one (Windows-based) so I can do this? Also, at us.php.net they mention that to enable sybase commands in PHP I need to add '--with-sybase-ct' to the php configuration. I don't know where this line should go, I haven't found any configuration files for PHP except PHP.ini, and its not in there.
Thanks.
sybase-ct only works on LINUX.
in order for PHP and sybase to work on a windows XP box, you need to install the sybase client libraries from sybase. they used to be free, but I don't know now. You might want to contact your sybase vendor to ask if they will supply them for you.
in order for PHP and sybase to work on a windows XP box, you need to install the sybase client libraries from sybase. they used to be free, but I don't know now. You might want to contact your sybase vendor to ask if they will supply them for you.
and you nned to have the sybase.dll extension enabled in your php.ini
if you setup apache and php on a linux server then you can use sybase-ct libraries to connect to it.
if you setup apache and php on a linux server then you can use sybase-ct libraries to connect to it.
ASKER
I did download Sybase's sqlanywhere library, which was a .dll. I added it to the 'ext' directory in my php folder and added an extension line for it in the php.ini, but when I try to call a function like 'sqlanywhere_connect' it says 'call to undefined function'.
We have no sybase vendor as the database came bundled with zenworks install.
We have no sybase vendor as the database came bundled with zenworks install.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
Vee_Mod
Community Support Moderator
Not sure that's something you want to get into ... but I'm not finding PHP binaries for Windows w/ the Sybase stuff already compiled in.
Is ASP.Net on IIS an option for you?