We help IT Professionals succeed at work.

php sybase adaptive server anywhere

antonioking
antonioking asked
on
1,486 Views
Last Modified: 2012-08-13
We have an application that runs using a sybase adaptive anywhere database.

How can I connect to this database using php, run an SQL query and return the results?

Kind regards
Comment
Watch Question

Author

Commented:
Hi thanks Jan..

Unfortuantely our server is version 9 so the link is unapplicable.
We are not in a position to upgrade the version either.

Are there not other methods to run SQL queries on the db?
SQL Anywhere instalation includes GUI client called Interactive SQL and command line client dbisql. They can be used to run queries on the db.
If you don't have these clients from your SQL Anywhere instalation, you may try to dowload client for new version (http://www.sybase.com/detail?id=1087327) - I believe, it should be backward compatible (however, I didn't try it myself).

Author

Commented:
Hi Jan,

I'm aware of the Interactive SQL client. But that doesn't help me run queries using php?
Well, I didn't see word php in your question "Are there not other methods to run SQL queries on the db?"

Author

Commented:
...

Are there not other methods to run SQL queries on the db USING PHP?
I can see directory src/php in my SQL Anywhere 9 instalation and it seems like php module is shipped with SQL Anywhere since version 9.0.2 (see http://php.net/manual/en/ref.sybase.php).

Another way is to use PHP module for ASE - it should work with Anywhere too.

Third option (but I'm not sure if it is supported on version 9) is to create web service and access Anywhere database through http interface - that way you probably don't need any php module at all.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Own solution that works
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.