FreeTDS Development Group

["jd wilson" <john.wilson AT savvis.net>]

I'm looking for some assistance with the errors encountered when running
'make test' for DBD-Sybase-0.94_02.

We are trying to get away from using Sybase's OC/S & ASE software in favor
of using FreeTDS to implement the ct-lib functionality.  (We're migrating
from Sybase to MS SQL Server, but we have existing perl code that we still
need to interface with ct-lib type functionality.  We have some experience
with TDS but none with DBI and DBD).

The target is MS SQL Server 2000 on Windows 2000.  (TDS 4.2 or 7.0 TBD). 
I have perl code that uses the ct_*() function calls and references  "use
Sybase::CTlib;" in the source.  I assume that if I'm using FreeTDS, that
this will be replaced by "use DBD::Sybase;"

I'm getting this error when running 'make test' for DBD-Sybase-0.94_02:

[jwilson@vntwb1da DBD-Sybase-0.94_02]$ make test
PERL_DL_NONLAZY=1 /home/jwilson/devel/usr/local/bin/perl -Iblib/arch
-Iblib/lib -I/home/jwilson/devel/usr/local/lib/perl5/5.00503/sun4-solaris
-I/home/jwilson/devel/usr/local/lib/perl5/5.00503 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/autocommit........install_driver(Sybase) failed: Can't load
'blib/arch/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: ld.so.1:
/home/jwilson/devel/usr/local/bin/perl: fatal: libgcc_s.so.1: open failed:
No such file or directory at
/home/jwilson/devel/usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
line 169.

 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
 at t/autocommit.t line 40
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-4
        Failed 3/4 tests, 25.00% okay
t/base..............install_driver(Sybase) failed: Can't load
'blib/arch/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: ld.so.1:
/home/jwilson/devel/usr/local/bin/perl: fatal: libgcc_s.so.1: open failed:
No such file or directory at
/home/jwilson/devel/usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
line 169.

These errors repeat for the remaining tests.  I am having a very difficult
time in resolving this problem.  I've searched the various resources and
have found references to changing -ltcl to -lsybtcl but I don't have this
lib.

I've got the following env setup:

[jwilson@vntwb1da DBD-Sybase-0.94_02]$ uname -a
SunOS vntwb1da 5.7 Generic_106541-19 sun4u sparc SUNW,Ultra-80

LD_LIBRARY_PATH=/home/jwilson/devel/usr/local/lib

SYBASE=/home/jwilson/devel/usr/local (this is where I installed FreeTDS
libs and includes)

In CONFIG:
        SYBASE=
        EXTRA_LIBS=-ltds
        
DBI_INCLUDE=/devel/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI


[jwilson@vntwb1da DBD-Sybase-0.94_02]$ make 
gcc -B/usr/ccs/bin/ -c -I/home/jwilson/devel/usr/local/include
-I/home/jwilson/devel/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O    -DVERSION=\"0.94_02\" -DXS_VERSION=\"0.94_02\"
-fPIC -I/home/jwilson/devel/usr/local/lib/perl5/5.00503/sun4-solaris/CORE 
Sybase.c
gcc -B/usr/ccs/bin/ -c -I/home/jwilson/devel/usr/local/include
-I/home/jwilson/devel/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O    -DVERSION=\"0.94_02\" -DXS_VERSION=\"0.94_02\"
-fPIC -I/home/jwilson/devel/usr/local/lib/perl5/5.00503/sun4-solaris/CORE 
dbdimp.c
dbdimp.c:2054:22: warning: multi-line string literals are deprecated
dbdimp.c:2064:22: warning: multi-line string literals are deprecated
Running Mkbootstrap for DBD::Sybase ()
chmod 644 Sybase.bs
LD_RUN_PATH="/home/jwilson/devel/usr/local/lib:/lib" gcc -B/usr/ccs/bin/
-B/usr/ccs/bin/ -o blib/arch/auto/DBD/Sybase/Sybase.so
-R/home/jwilson/devel/usr/local/lib -R/lib
-L/home/jwilson/devel/usr/local/lib -Wl,-E -G -L/usr/local/lib Sybase.o
dbdimp.o    -L/home/jwilson/devel/usr/local/lib -lct -lintl -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
[jwilson@vntwb1da DBD-Sybase-0.94_02]$ 

I have tried what I thought was every conceivable configuration, but
nothing is working.

In looking at the comment in the source code about the error
"DynaLoader.pm line 169."  It refers to a problem with loading C code and
.xs files.  But no solution is offered.  (I'm not a perl expert can you
tell?).

One thing to note is that the perl I'm using (5.00503) has been recently
rebuilt on this server using gcc 3.0.3.  Also the DBI module was built and
tested under this same configuration and it does not have any problem
loading DBI when the source encounters a "use DBI;" call.

Any help would be much appreciated.

regards,
j d wilson