[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Suggestions for a php/sybase sql server

Posted on 2007-10-14
7
Medium Priority
?
1,051 Views
Last Modified: 2013-12-13
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.
0
Comment
Question by:sledneck
6 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 20076481
--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
 
LVL 17

Expert Comment

by:nplib
ID: 20079408
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
 
LVL 17

Expert Comment

by:nplib
ID: 20079442
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 1

Author Comment

by:sledneck
ID: 20081804
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
 
LVL 1

Accepted Solution

by:
sledneck earned 0 total points
ID: 20083005
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
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20117541
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses
Course of the Month18 days, 1 hour left to enroll

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question