FreeTDS stuff
Basically there's two ways to go: Using FreeTDS, or using the Sybase libs that ship w/ OMNIbus and the Sybase headers from the MM page. The way it works is:
|
FreeTDS |
Sybase Libs |
|
FreeTDS patch |
Needed |
N/A |
ftds-nco-0.63.patch This is a patch for FreeTDS, it should apply cleanly to v0.63. Requires using GNU patch utility from http://www.sunfreeware.com (Previous patch: ftds-nco-0.62.4.patch ) |
DBD-Sybase patch |
Needed |
Needed |
dbd_syb-nco_syb-107.patch This is patch v1.07 against DBD::Sybase. (Previous patches: dbd-syb-1.02.patch , dbd-syb-1.04.patch , dbd-syb-1.05.patch ) Differences between Micromuse patch and this one - Micromuse patch does not fix the 'ping' method of DBD::Sybase which lets to test to make sure that the connection is still up. Very useful. - Micromuse patch does not fix the Netcool NULL padding issue. Instead they force you to fix this in your scripts. |
PHP patch |
Not Needed |
Needed |
php-nco-syb-107.patch This is patch v1 for PHP, tested with version 4.4.1. Differences between FreeTDS patch and this one - This patch will only work with Netcool. It *WILL* break your ability to use the same copy of DBD-Sybase and/or PHP to connect to a "real" Sybase or MS SQL server. - This patch supports the use of "virtual" servers in omni.dat (eg, the Backup: lines). FreeTDS does not currently support backup servers. - This patch works with the native Netcool libraries, so you don't need to install FreeTDS. One less thing to compile! |
NOTE: You will need the Sybase library headers to compile DBD::Sybase and/or PHP against the native Netcool libraries. If you don't have these, you can grab a copy of them from the Micromuse package.
NOTE: Do not apply both the PHP patch and the FreeTDS patch to the same system. If you patch FreeTDS and link PHP to that FreeTDS, you're done.
DustinMarquess has also released some FDS patches