The good news is with:
Perl : 5.008007 (i686-linux)
OS : linux (2.4.21-243-default)
DBI : 1.48
DBD::Sybase : 1.06
freetds v0.63
(./configure --prefix=/usr/local/freetds --with-tdsver=7.0)
I can connect to and query the following MS-SQL servers:
Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: )
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So everything looks like its working fine.
I did get quite a few build errors though, and only half of them (or so) are
listed in
DBD-Sybase-1.06/README.freetds
so I thought I'd post my build dialogue here. I'm ignoring all the errors below
unless someone slaps me.
Cheers,
j
-----------------------
force install DBD::Sybase
Removing previously used /root/.cpan/build/DBD-Sybase-1.06
CPAN.pm: Going to build M/ME/MEWP/DBD-Sybase-1.06.tar.gz
Unknown Client Library version - assuming FreeTDS.
By default DBD::Sybase 1.05 and later use the 'CHAINED' mode (where available)
when 'AutoCommit' is turned off. Versions 1.04 and older instead managed
the transactions explicitly with a 'BEGIN TRAN' before the first DML
statement. Using the 'CHAINED' mode is preferable as it is the way that
Sybase implements AutoCommit handling for both its ODBC and JDBC drivers.
Use 'CHAINED' mode by default (Y/N) [Y]: Y
The DBD::Sybase module need access to a Sybase server to run the tests.
To clear an entry please enter 'undef'
Sybase server to use (default: SYBASE): omares-pms
User ID to log in to Sybase (default: sa):
Password (default: undef): Sybase database to use on omares-pms (default:
undef): hotel
* Writing login information, including password, to file PWD.
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lcs
Note (probably harmless): No library found for -lsybtcl
Note (probably harmless): No library found for -lcomn
Note (probably harmless): No library found for -lintl
Note (probably harmless): No library found for -lblk
Using DBI 1.48 (for perl 5.008007 on i686-linux) installed in
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI/
Writing Makefile for DBD::Sybase
cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod
cp Sybase.pm blib/lib/DBD/Sybase.pm
/usr/local/bin/perl5.8.7 -p -e "s/~DRIVER~/Sybase/g"
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI//Driver.xst >
Sybase.xsi
/usr/local/bin/perl5.8.7 /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.7/ExtUtils/typemap Sybase.xs > Sybase.xsc && mv
Sybase.xsc Sybase.c
cc -c -I/usr/local/freetds/include
-I/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -fno-strict-aliasing
-pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic
"-I/usr/local/lib/perl5/5.8.7/i686-linux/CORE" Sybase.c
cc -c -I/usr/local/freetds/include
-I/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -fno-strict-aliasing
-pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic
"-I/usr/local/lib/perl5/5.8.7/i686-linux/CORE" dbdimp.c
Running Mkbootstrap for DBD::Sybase ()
chmod 644 Sybase.bs
rm -f blib/arch/auto/DBD/Sybase/Sybase.so
LD_RUN_PATH="/usr/local/freetds/lib" cc -L/usr/local/freetds/lib -shared
-L/usr/local/lib Sybase.o dbdimp.o -o blib/arch/auto/DBD/Sybase/Sybase.so
-L/usr/local/freetds/lib -lct -ltds -ldl -lm
chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so
cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs
chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs
Manifying blib/man3/DBD::Sybase.3
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl5.8.7 "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/autocommit....ok
t/base..........ok
t/exec..........NOK 5
# Failed test (t/exec.t at line 41)
t/exec..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5, 8-22
Failed 16/22 tests, 27.27% okay
t/fail..........NOK 4
# Failed test (t/fail.t at line 35)
t/fail..........NOK 6
# Failed test (t/fail.t at line 47)
ct_send(CS_DESCRIBE_INPUT) returned 0 at blib/lib/DBD/Sybase.pm line 133.
t/fail..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 4, 6-12
Failed 8/12 tests, 33.33% okay
t/login.........ok
t/main..........ok 16/33Setting of CS_OPT_TEXTSIZE failed. at t/main.t line 95.
t/main..........NOK 18
# Failed test (t/main.t at line 100)
t/main..........NOK 19
# Failed test (t/main.t at line 103)
t/main..........NOK 21
# Failed test (t/main.t at line 114)
type_info_all result has 19 keys but 20 fields at t/main.t line 140
# Looks like you planned 33 tests but only ran 22.
# Looks like your test died just after 22.
t/main..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 18-19, 21, 23-33
Failed 14/33 tests, 57.58% okay
t/multi_sth.....ok 1/43ct_send(CS_DESCRIBE_INPUT) returned 0 at
/root/.cpan/build/DBD-Sybase-1.06/blib/lib/DBD/Sybase.pm line 133.
t/multi_sth.....dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 10-43
Failed 34/43 tests, 20.93% okay
t/nsql..........ok
t/place.........ok 1/13ct_send(CS_DESCRIBE_INPUT) returned 0 at
/root/.cpan/build/DBD-Sybase-1.06/blib/lib/DBD/Sybase.pm line 133.
t/place.........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5-13
Failed 9/13 tests, 30.77% okay
t/thread........skipped
all skipped: this perl 5.008007 not configured to support iThreads
t/xblk..........NOK 6
# Failed test (t/xblk.t at line 84)
t/xblk..........NOK 7
# Failed test (t/xblk.t at line 84)
t/xblk..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 6-62
Failed 57/62 tests, 8.06% okay
t/xblob.........ok 1/11Use of uninitialized value in print at t/xblob.t line 49.
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 56.
t/xblob.........NOK 6
# Failed test (t/xblob.t at line 79)
Use of uninitialized value in print at t/xblob.t line 121.
DBD::Sybase::st syb_ct_send_data failed: Server message number=170 severity=15
state=1 line=1 server=OMARES-PMS text=Line 1: Incorrect syntax near
'0x00000000000000000000000000000000'. at t/xblob.t line 125.
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 129.
t/xblob.........NOK 10
# Failed test (t/xblob.t at line 153)
# Looks like you failed 2 tests of 11.
t/xblob.........dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 6, 10
Failed 2/11 tests, 81.82% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/exec.t 0 11 22 31 140.91% 5 8-22
t/fail.t 0 11 12 14 116.67% 4 6-12
t/main.t 255 65280 33 25 75.76% 18-19 21 23-33
t/multi_sth.t 0 11 43 68 158.14% 10-43
t/place.t 0 11 13 18 138.46% 5-13
t/xblk.t 0 11 62 112 180.65% 6-62
t/xblob.t 2 512 11 2 18.18% 6 10
1 test skipped.
Failed 7/12 test scripts, 41.67% okay. 140/221 subtests failed, 36.65% okay.
make: *** [test_dynamic] Error 2
/usr/bin/make test -- NOT OK
Running make install
Installing
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBD/Sybase/Sybase.so
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Installing /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBD/Sybase.pm
Installing /usr/local/man/man3/DBD::Sybase.3
Writing
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBD/Sybase/.packlist
Appending installation info to
/usr/local/lib/perl5/5.8.7/i686-linux/perllocal.pod
/usr/bin/make install -- OK
