Skip to Content.
Sympa Menu

freetds - [freetds] Unable to install Sybperl & DBD::Sybase with freeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: chiang.tan AT truenergy.com.au
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Unable to install Sybperl & DBD::Sybase with freeTDS
  • Date: Wed, 21 Jun 2006 11:04:46 +1000

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






Archive powered by MHonArc 2.6.24.

Top of Page