Sybase is one of those systems that can be sometimes finicky to setup on the client side. I was pleasantly surprised to see that PHP has support for Sybase. When you need to quickly prototype a new feature or give your user’s a quick dynamic report, PHP can be a great path to go.
It took a little research to get all the parts necessary, but the installation is very smooth.
- Install WAMP
- Install Sybase client (you want the open client; login/pass required)
- Update php.ini to: enable sybase extension (extension=php_sybase_ct.dll)
- specify location of sybase sql.ini file (sybase.interface_file = “c:\sybase\ini\sql.ini”)
To test the connection we can do a simle query against a table: