| 1 |
|
| 2 |
Using DBD::Sybase with FreeTDS |
| 3 |
============================== |
| 4 |
|
| 5 |
DBD::Sybase 1.17 or later works reasonably well with FreeTDS 1.18.x, |
| 6 |
but some capabilities are limited or not available. |
| 7 |
|
| 8 |
Build process: |
| 9 |
-------------- |
| 10 |
|
| 11 |
FreeTDS normally installs in /usr/local, with the libraries in |
| 12 |
/usr/local/lib and the include files in /usr/local/include. This |
| 13 |
location is assumed below. |
| 14 |
|
| 15 |
To build DBD::Sybase you need to set the SYBASE environment variable |
| 16 |
to /usr/local. When you now run "perl Makefile.PL" you will get |
| 17 |
warnings for a few missing libraries: |
| 18 |
Note (probably harmless): No library found for -lcs |
| 19 |
Note (probably harmless): No library found for -lsybtcl |
| 20 |
Note (probably harmless): No library found for -lcomn |
| 21 |
Note (probably harmless): No library found for -lintl |
| 22 |
This is OK because FreeTDS doesn't package the functions in the |
| 23 |
same libraries as Sybase. |
| 24 |
|
| 25 |
The "make test" process will fail for a number of tests when run |
| 26 |
against a Sybase ASE server: |
| 27 |
|
| 28 |
Test Summary Report |
| 29 |
------------------- |
| 30 |
t/main.t (Wstat: 512 Tests: 38 Failed: 2) |
| 31 |
Failed tests: 33-34 |
| 32 |
Non-zero exit status: 2 |
| 33 |
t/utf8.t (Wstat: 1792 Tests: 11 Failed: 7) |
| 34 |
Failed tests: 1, 4-6, 9-11 |
| 35 |
Non-zero exit status: 7 |
| 36 |
t/xblob.t (Wstat: 65280 Tests: 5 Failed: 0) |
| 37 |
Non-zero exit status: 255 |
| 38 |
Parse errors: Bad plan. You planned 11 tests but ran 5. |
| 39 |
Files=13, Tests=239, 16 wallclock secs ( 0.06 usr 0.03 sys + 0.72 cusr 0.40 csys = 1.21 CPU) |
| 40 |
Result: FAIL |
| 41 |
Failed 3/13 test programs. 9/239 subtests failed. |
| 42 |
|
| 43 |
Specifically, FreeTDS 1.18.x does not support "unsigned smallint", fails in handling utf8 data |
| 44 |
when fetched from an ASE server, and fails in the ct_data_info() call used in TEXT/IMAGE handling. |
| 45 |
|
| 46 |
I personally use FreeTDS when working on DBD::Sybase, given that my main computer is an iMac and |
| 47 |
there are no Sybase libraries available :-) |
| 48 |
|
| 49 |
|