(RADIATOR) Access SQL 2000 from Solaris 8

Fri May 24 10:48:05 CDT 2002

I took Mike's approach first and installed 
freetds 0.53 with DBD-Sybase 0.94
I set my sybase variable to /usr/local/freetds, 
added extra_libs
EXTRA_LIBS= -ltli (as per the CONFIG file)
and added my platypus server to the freetds.conf file.

Compiling DBD-Sybase and doing the make test showed a lot of failures. 

PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib 
-I/usr/local/lib/perl5/5.6.1/i86pc-solaris -I/usr/local/lib/per
l5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; 
runtests @ARGV;' t/*.t
t/autocommit........dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-4
        Failed 3/4 tests, 25.00% okay
t/base..............ok
t/exec..............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-9
        Failed 8/9 tests, 11.11% okay
t/fail..............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-13
        Failed 12/13 tests, 7.69% okay
t/login.............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-3
        Failed 2/3 tests, 33.33% okay
t/main..............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-14
        Failed 13/14 tests, 7.14% okay
t/nsql..............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-4
        Failed 3/4 tests, 25.00% okay
t/place.............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-11
        Failed 10/11 tests, 9.09% okay
t/xblob.............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 2-6
        Failed 5/6 tests, 16.67% okay
Failed Test    Status Wstat Total Fail  Failed  List of Failed
--------------------------------------------------------------------------------
t/autocommit.t     0    11     4    3  75.00%  2-4
t/exec.t           0    11     9    8  88.89%  2-9
t/fail.t           0    11    13   12  92.31%  2-13
t/login.t          0    11     3    2  66.67%  2-3
t/main.t           0    11    14   13  92.86%  2-14
t/nsql.t           0    11     4    3  75.00%  2-4
t/place.t          0    11    11   10  90.91%  2-11
t/xblob.t          0    11     6    5  83.33%  2-6
Failed 8/9 test scripts, 11.11% okay. 56/69 subtests failed, 18.84% okay.
*** Error code 2
make: Fatal error: Command failed for target `test_dynamic'

I also got errors on my freetds install:

root at mail/opt/freetds-0.53% make check
Making check in include
Making check in src
Making check in tds
Making check in unittests
make  t0001 t0002 t0003  t0004 t0005 t0006
`t0001' is up to date.
`t0002' is up to date.
`t0003' is up to date.
`t0004' is up to date.
`t0005' is up to date.
`t0006' is up to date.
make  check-TESTS
t0001.c: Testing login, logout
PASS: t0001
t0002.c: Test basic submit query, results
PASS: t0002
t0003.c: Testing DB change -- 'use tempdb'
PASS: t0003
t0004.c: Test large (>512 bytes) queries
tds_process_result_tokens() returned TDS_FAIL for long query
FAIL: t0004
t0005.c: Test large (>512 bytes) replies
PASS: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
PASS: t0006
===================
1 of 6 tests failed
===================
*** Error code 1
make: Fatal error: Command failed for target `check-TESTS'
Current working directory /opt/freetds-0.53/src/tds/unittests
*** Error code 1
make: Fatal error: Command failed for target `check-am'
Current working directory /opt/freetds-0.53/src/tds/unittests
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'
Current working directory /opt/freetds-0.53/src/tds
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'
Current working directory /opt/freetds-0.53/src
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'

I did the make install on both for kicks.  I setup my AuthBy PLATYPUS and 
tried a 
test user, but it causes radiator to died.  Setting Trace to 5 doesn't 
show anything useful.  Should I be focusing on getting all these tests to 
run cleanly, or is it normal for certain ones to fail?

Thanks

On Fri, 24 May 2002, Hugh Irvine wrote:

> 
> Hello -
> 
> You might also consider using the DBD-Proxy approach and I will forward you a 
> related piece of mail from Mike as well.
> 
> Otherwise have a look at the archive site and do a search.
> 
> regards
> 
> Hugh
> 
> 
> On Fri, 24 May 2002 05:58, Sysadmin wrote:
> > Hello,
> >   I've taken on the challege of getting my Solaris 8 x86 server talking to
> > my W2K server running SQL 2000.  I've read through the FAQ and still have
> > a few questions before I start installing.  I would like to do it with the
> > freeware products available if possible.  I was looking at freetds and
> > DBD-sybase.  The radiator faq talks about sql 2000, but from the freetds
> > faq, it
> > says sql 2000 is not fully supported and to use TDS 7.0.  I'm confused
> > about the different formats.  Will TDS 7.0 actuall work with sql 2000?
> > I'm going to be interfacing with the accounting package Platypus.
> > Once these two packages (and any other dependant packages) are installed,
> > I should just be able to configure radiator's config file to AuthBy
> > PLATYPUS with the correct information?
> >   Is anyone else runs solaris 8 x86 with radiator and sql 2000?
> >
> > Thanks
> >
> >
> >
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> 
> 

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.