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