FreeTDS Development Group

[chiang.tan AT truenergy.com.au]

Hi
I managed to install freeTDS on Sun Solaris 2.8, and have no problem 
connecting to MS SQL using tsql.

However, I couldn't manage to install Sybperl & DBD::Sybase properly. 
Below are the error message I got.  Can someone give me a hand on how to 
install Sybperl & DBD::Sybase properly?
DBD install failed with the following???.. 
 
#     Failed test (t/xblk.t at line 95) 
t/xblk..........dubious    
       Test returned status 0 (wstat 139, 0x8b) 
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 57. 
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 64. 
Use of uninitialized value in unpack at t/xblob.t line 77. 
 
#     Failed test (t/xblob.t at line 87) 
t/xblob.........NOK 6Use of uninitialized value in print at t/xblob.t line 
129. 
DBD::Sybase::st syb_ct_send_data failed: Server message number=170 
severity=15 state=1 line=1 server=GRANITE text=Line 1: Incorrect syntax 
near '0x00000000000000000000000000000000'. at t/xblob.t line 133. 
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 137. 
Use of uninitialized value in unpack at t/xblob.t line 151. 


Sybperl failed with the following? 
 
To install the new "perl" binary, call 
   make -f Makefile.aperl inst_perl MAP_TARGET=perl 
To remove the intermediate files say 
   make -f Makefile.aperl map_clean 
PERL_DL_NONLAZY=1 ./perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 
'blib/lib', 'blib/arch')" t/*.t 
t/1_db_dblib...........FAILED tests 20-22    
       Failed 3/22 tests, 86.36% okay 
t/1_db_money...........FAILED tests 2, 9-13    
       Failed 6/13 tests, 53.85% okay 
t/2_ct_ctlib...........cs_cmp(CS_DATETIME) failed at 
/var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm line 104. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 195. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 205. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 195. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 190. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_calc(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 205. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
cs_cmp(CS_NUMERIC) failed at 
/var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm line 238. 
cs_cmp(CS_NUMERIC) failed at 
/var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm line 238. 
cs_cmp(CS_MONEY) failed at /var/tmp/sybperl-2.18/blib/lib/Sybase/CTlib.pm 
line 184. 
t/2_ct_ctlib...........NOK 26Test output counter mismatch [test 26]    
t/2_ct_ctlib...........FAILED tests 2, 14, 25-30  
       Failed 8/30 tests, 73.33% okay 
t/2_ct_cursor..........Use of uninitialized value in split at 
t/2_ct_cursor.t line 35. 
Use of uninitialized value in numeric lt (<) at t/2_ct_cursor.t line 36. 
Cursors are not available on this SQL Server. 
t/2_ct_cursor..........ok    
t/2_ct_nsql............ok    
t/2_ct_prepare......... 
Server message: 
Message number: 260, Severity 16, State 1, Line 1 
Server 'GRANITE' 
Message String: Disallowed implicit conversion from data type varchar to 
data type money, table 
'tempdb.dbo.#ttt________________________________________________________________________________________________________________0000000057C6',
 
column 'ddd'. Use the CONVERT function to run this query. 
 
Server message: 
Message number: 8180, Severity 16, State 1, Line 1 
Server 'GRANITE' 
Message String: Statement(s) could not be prepared. 
t/2_ct_prepare.........dubious  
       Test returned status 0 (wstat 139, 0x8b) 
t/2_ct_xblk............blk_alloc not implemented on this architecture at 
t/2_ct_xblk.t line 38. 
t/2_ct_xblk............dubious  
       Test returned status 255 (wstat 65280, 0xff00) 
DIED. FAILED tests 3-21 
       Failed 19/21 tests, 9.52% okay 
t/3_bcp................Sybase message 102, Severity 15, state 5 
Server `GRANITE' 
Line 1 
   Incorrect syntax near 'lock'. 
 
   1> create table loaddb..bcp(f1 char(5), f2 int, f3 text) lock allpages 
Sybase message 208, Severity 16, state 1 
Server `GRANITE' 
Line 1 
   Invalid object name 'loaddb..bcp'. 
 
   1> 
   2> select c.name, t.name 
   3> from loaddb.dbo.syscolumns c, loaddb.dbo.systypes t 
   4> where c.id = object_id('loaddb..bcp') 
   5> and   c.usertype *= t.usertype 
bcp_init failed. at t/3_bcp.t line 53 
t/3_bcp................dubious  
       Test returned status 2 (wstat 512, 0x200) 
DIED. FAILED tests 3, 5-9 
       Failed 6/9 tests, 33.33% okay 
t/4_blk................ok 1/19blk_alloc not implemented on this 
architecture at /var/tmp/sybperl-2.18/blib/lib/Sybase/BLK.pm line 494. 
t/4_blk................dubious  
       Test returned status 255 (wstat 65280, 0xff00) 
DIED. FAILED tests 5-19 
       Failed 15/19 tests, 21.05% okay 
t/5_sybperl............ok    
t/5_sybperl_dbmoney....dubious  
       Test returned status 0 (wstat 139, 0x8b) 
Failed Test           Stat Wstat Total Fail  Failed  List of Failed 
-------------------------------------------------------------------------------
 

t/1_db_dblib.t                      22    3  13.64%  20-22 
t/1_db_money.t                      13    6  46.15%  2 9-13 
t/2_ct_ctlib.t                      30    8  26.67%  2 14 25-30 
t/2_ct_prepare.t         0   139    ??   ??       %  ?? 
t/2_ct_xblk.t          255 65280    21   38 180.95%  3-21 
t/3_bcp.t                2   512     9   11 122.22%  3 5-9 
t/4_blk.t              255 65280    19   30 157.89%  5-19 
t/5_sybperl_dbmoney.t    0   139    ??   ??       %  ?? 
Failed 8/11 test scripts, 27.27% okay. 56/168 subtests failed, 66.67% 
okay. 
*** Error code 255 
Make: Fatal error: Command failed for target `test_static' 
 

Cheers,
Chiang Tan
-- 
We're excited by gas & electricity.NOTICEThis email and any files transmitted 
with it may be confidential and are intended solely for the use of the 
individual or entity to whom they are addressed. Any confidentiality is not 
waived or lost because this email has been sent to you by mistake. This email 
may contain personal information of individuals, and be subject to 
Commonwealth and/or State privacy laws in Australia.This email is also 
subject to copyright. If you are not the intended recipient, you must not 
read, print, store, copy, forward or use this email for any reason, in 
accordance with privacy and copyright laws. If you have received this email 
in error, please notify the sender by return email, and delete this email 
from your inbox.The recipient should check this email and any attachments for 
the presence of viruses. We do not accept liability for any computer virus, 
data corruption, delay, interruption, unauthorized access or unauthorised 
amendment.TRUenergy Australia Pty Ltd ABN 96 071 611 017

Message  protected by MailGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.mailguard.com.au/mg