Suggestions for a php/sybase sql server

Posted on 2007-10-14
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:

Sybase ASA 8.0.2
running on Netware 6.5 SP6
Database is part of Zenworks (it holds workstation inventory)

Web Server:
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 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.

Question by:sledneck
    LVL 32

    Expert Comment

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

    Expert Comment

    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.

    LVL 17

    Expert Comment

    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.
    LVL 1

    Author Comment

    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.
    LVL 1

    Accepted Solution

    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.
    LVL 1

    Expert Comment

    Closed, 125 points refunded.
    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now