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.
LVL 1
sledneckAsked:
Who is Participating?
 
sledneckAuthor Commented:
Ok I found a solution that will work for now. I have Sybase's ODBC connector, I put it on the server station and then used the ODBC functions of PHP which were already compiled into XAMPP to access the server. Thanks for the suggestions though folks.
0
 
Daniel WilsonCommented:
--with-sybase-ct is a flag to use when compiling PHP.

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?
0
 
nplibCommented:
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.

0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
nplibCommented:
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.
0
 
sledneckAuthor Commented:
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.
0
 
Vee_ModCommented:
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.