1$Id: README.freetds,v 1.2 2003/04/03 19:07:00 mpeppler Exp $ 2 3Using DBD::Sybase with FreeTDS 4============================== 5 6DBD::Sybase 1.00 or later works reasonably well with FreeTDS 0.61, 7but some capabilities are limited or not available. 8 9Build process: 10-------------- 11 12FreeTDS normally installs in /usr/local, with the libraries in 13/usr/local/lib and the include files in /usr/local/include. This 14location is assumed below. 15 16To build DBD::Sybase you need to set the SYBASE environment variable 17to /usr/local. When you now run "perl Makefile.PL" you will get 18warnings for a few missing libraries: 19 Note (probably harmless): No library found for -lcs 20 Note (probably harmless): No library found for -lsybtcl 21 Note (probably harmless): No library found for -lcomn 22 Note (probably harmless): No library found for -lintl 23This is OK because FreeTDS doesn't package the functions in the 24same libraries as Sybase. 25 26The "make test" process will fail for a number of tests: 27 28Failed Test Stat Wstat Total Fail Failed List of Failed 29------------------------------------------------------------------------------- 30t/exec.t 0 139 ?? ?? % ?? 31t/main.t 16 2 12.50% 13-14 32t/xblob.t 6 2 33.33% 5-6 3313 subtests skipped. 34 35This is expected. 36 37Missing Features: 38----------------- 39 40* ?-style placeholders are not supported. 41* Setting $dbh->{LongReadLen} doesn't work 42 Use $dbh->do("set textsize <value>") instead. 43* The special text/image handling functions don't work 44 (i.e. ct_fetch_data(), etc). 45* The $dbh->{syb_row_count} attribute doesn't work. 46 Use $dbh->do("set rowcount <value>") instead. 47* The $dbh->{syb_quoted_identifier} attribute doesn't work. 48 Use $dbh->do("set quoted_identifier <value>") instead. 49 50Bugs: 51----- 52 53FreeTDS 0.61 has a bug when executing queries that return 0 rows, 54which manifests itself when trying to do a fetchrow_hashref() 55after such a query with the following error: 56 57 Can't get DBI::st=HASH(0x811cfa8)->{NAME}: unrecognised attribute at... 58 59This is fixed in the 0.62-dev version of FreeTDS. 60 61 62