Problems with DBD::Sybase compiling/linking

I am trying to build DBD::Sybase for ASE12.5.1 on AIX. I tried the
latest one - DBD-Sybase-1.07_09 and for a comparison - relatively old
and stable release: DBD-Sybase-1.07

Both failed on compilation/linking (make) step for different
reasons. I could not find similar problems reported on the user
group, therefore I am posting it here. Any help will be greatly
appreciated.

These are just error messages from 'make'. Below, you can find
complete outputs for all steps:

DBD-Sybase-1.07_09

"dbdimp.c", line 1146.1: 1506-276 (S) Syntax error: possible missing
'{'?

make: 1254-004 The error code from the last command is 1.

Stop.

DBD-Sybase-1.07

ld: 0711-317 ERROR: Undefined symbol: .ct_dynamic

ld: 0711-317 ERROR: Undefined symbol: .ct_command

ld: 0711-317 ERROR: Undefined symbol: .ct_param

ld: 0711-317 ERROR: Undefined symbol: .cs_convert

ld: 0711-317 ERROR: Undefined symbol: .ct_cancel

ld: 0711-317 ERROR: Undefined symbol: .ct_close

ld: 0711-317 ERROR: Undefined symbol: .cs_diag

ld: 0711-317 ERROR: Undefined symbol: .blk_bind

ld: 0711-317 ERROR: Undefined symbol: .blk_rowxfer

ld: 0711-317 ERROR: Undefined symbol: .ct_results

ld: 0711-317 ERROR: Undefined symbol: .ct_res_info

ld: 0711-317 ERROR: Undefined symbol: .ct_fetch

ld: 0711-317 ERROR: Undefined symbol: .ct_capability

ld: 0711-317 ERROR: Undefined symbol: .ct_send

ld: 0711-317 ERROR: Undefined symbol: .ct_describe

ld: 0711-317 ERROR: Undefined symbol: .ct_cmd_drop

ld: 0711-317 ERROR: Undefined symbol: .blk_done

ld: 0711-317 ERROR: Undefined symbol: .ct_bind

ld: 0711-317 ERROR: Undefined symbol: .cs_dt_info

ld: 0711-317 ERROR: Undefined symbol: .cs_dt_crack

ld: 0711-317 ERROR: Undefined symbol: .ct_options

ld: 0711-317 ERROR: Undefined symbol: .blk_drop

ld: 0711-317 ERROR: Undefined symbol: .blk_alloc

ld: 0711-317 ERROR: Undefined symbol: .blk_props

ld: 0711-317 ERROR: Undefined symbol: .blk_init

ld: 0711-317 ERROR: Undefined symbol: .blk_describe

ld: 0711-317 ERROR: Undefined symbol: .ct_config

ld: 0711-317 ERROR: Undefined symbol: .cs_loc_alloc

ld: 0711-317 ERROR: Undefined symbol: .cs_locale

ld: 0711-317 ERROR: Undefined symbol: .ct_con_alloc

ld: 0711-317 ERROR: Undefined symbol: .ct_con_props

ld: 0711-317 ERROR: Undefined symbol: .ct_connect

ld: 0711-317 ERROR: Undefined symbol: .ct_con_drop

ld: 0711-317 ERROR: Undefined symbol: .ct_cmd_alloc

ld: 0711-317 ERROR: Undefined symbol: .ct_compute_info

ld: 0711-317 ERROR: Undefined symbol: .ct_send_data

ld: 0711-317 ERROR: Undefined symbol: .ct_data_info

ld: 0711-317 ERROR: Undefined symbol: .ct_get_data

ld: 0711-317 ERROR: Undefined symbol: .cs_loc_drop

ld: 0711-317 ERROR: Undefined symbol: .cs_ctx_alloc

ld: 0711-317 ERROR: Undefined symbol: .cs_config

ld: 0711-317 ERROR: Undefined symbol: .ct_init

ld: 0711-317 ERROR: Undefined symbol: .cs_ctx_drop

ld: 0711-317 ERROR: Undefined symbol: .ct_callback

ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.

make: 1254-004 The error code from the last command is 8.

Stop.





Environment:

-- AIX -64bit

-- Sybase ASE12.5.1-64bit

-- Perl: "This is perl, v5.8.0 built for aix Copyright 1987-2002,
Larry Wall' (it looks like the core Perl was compiled by 'gcc')

-- There is standard AIX 'cc' compiler on my staging machine (so I
had to modify Makefile to change ;gcc' to 'cc'

-- I used the latest DBI 1.54 and built it before building DBD



Building DBD::Sybase 1.07-9

Running 'perl Makefile.PL'



p4-lpar2:/usr/local/sybase/socdbaud.sybase/src/DBD-Sybase-1.07_09>perl
Makefile.PL

Sybase OpenClient 12.5.1 ASE Edition found.



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]:



BLK api available - found: blk_r64 blk64

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): DBENG001

User ID to log in to Sybase (default: sa):

Password (default: undef):



Sybase database to use on DBENG001 (default: undef): pubs2



* Writing login information, including password, to file PWD.



Checking if your kit is complete...

Looks good

Note (probably harmless): No library found for -lct

Note (probably harmless): No library found for -lcs

Note (probably harmless): No library found for -ltcl

Note (probably harmless): No library found for -lcomn

Note (probably harmless): No library found for -lblk

Using DBI 1.54 (for perl 5.008 on aix) installed in /opt/perl/v5.8.0/
lib/site_perl/5.8.0/aix/auto/DBI/

Writing Makefile for DBD::Sybase







Running 'make' for DBD



p4-lpar2:/usr/local/sybase/socdbaud.sybase/src/DBD-Sybase-1.07_09>make

cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod

cp Sybase.pm blib/lib/DBD/Sybase.pm

/usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME"
=> "DBD::Sybase", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" =>
[]);'

/usr/bin/perl -p -e "s/~DRIVER~/Sybase/g" /opt/perl/v5.8.0/lib/
site_perl/5.8.0/aix/auto/DBI/Driver.xst > Sybase.xsi

/usr/bin/perl /opt/perl/v5.8.0/lib/5.8.0/ExtUtils/xsubpp -
typemap /opt/perl/v5.8.0/lib/5.8.0/ExtUtils/typemap Sybase.xs >
Sybase.xsc && mv Sybase.xsc Sybase.c

cc -c -I/usr/local/sybase/ds12_5/OCS-12_5/include -I/opt/perl/
v5.8.0/lib/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE -
D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-
aliasing -D_LARGE_FILES -O -DVERSION=\"1.07_09\" -DXS_VERSION=
\"1.07_09\" "-I/opt/perl/v5.8.0/lib/5.8.0/aix/CORE" Sybase.c

cc -c -I/usr/local/sybase/ds12_5/OCS-12_5/include -I/opt/perl/
v5.8.0/lib/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE -
D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-
aliasing -D_LARGE_FILES -O -DVERSION=\"1.07_09\" -DXS_VERSION=
\"1.07_09\" "-I/opt/perl/v5.8.0/lib/5.8.0/aix/CORE" dbdimp.c

"dbdimp.c", line 1146.1: 1506-276 (S) Syntax error: possible missing
'{'?

make: 1254-004 The error code from the last command is 1.





Stop.





Just for comparison: Building DBD::Sybase 1.07

Running 'perl Makefile.PL'



p4-lpar2:/usr/local/sybase/socdbaud.sybase/src/DBD-Sybase-1.07>perl
Makefile.PL

Sybase OpenClient 12.5.1 ASE Edition found.



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]:



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): DBENG001

User ID to log in to Sybase (default: sa):

Password (default: undef):

Sybase database to use on DBENG001 (default: undef): pubs2



* Writing login information, including password, to file PWD.



Note (probably harmless): No library found for -lct

Note (probably harmless): No library found for -lcs

Note (probably harmless): No library found for -ltcl

Note (probably harmless): No library found for -lcomn

Note (probably harmless): No library found for -lblk

Using DBI 1.54 (for perl 5.008 on aix) installed in /opt/perl/v5.8.0/
lib/site_perl/5.8.0/aix/auto/DBI/

Writing Makefile for DBD::Sybase



Running 'make'



p4-lpar2:/usr/local/sybase/socdbaud.sybase/src/DBD-Sybase-1.07>make

cc -c -I/usr/local/sybase/ds12_5/OCS-12_5/include -I/opt/perl/
v5.8.0/lib/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE -
D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-
aliasing -D_LARGE_FILES -O -DVERSION=\"1.07\" -DXS_VERSION=
\"1.07\" "-I/opt/perl/v5.8.0/lib/5.8.0/aix/CORE" Sybase.c

cc -c -I/usr/local/sybase/ds12_5/OCS-12_5/include -I/opt/perl/
v5.8.0/lib/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE -
D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-
aliasing -D_LARGE_FILES -O -DVERSION=\"1.07\" -DXS_VERSION=
\"1.07\" "-I/opt/perl/v5.8.0/lib/5.8.0/aix/CORE" dbdimp.c

"dbdimp.c", line 4779.48: 1506-280 (W) Function argument assignment
between types "int*" and "unsigned long*" is not allowed.

Running Mkbootstrap for DBD::Sybase ()

chmod 644 Sybase.bs

rm -f blib/arch/auto/DBD/Sybase/Sybase.so

LD_RUN_PATH="/lib" cc -L/usr/local/sybase/ds12_5/OCS-12_5/
lib -Wl,-bhalt:4 -Wl,-bM:SRE -Wl,-bI:/opt/perl/v5.8.0/lib/5.8.0/aix/
CORE/perl.exp -Wl,-bE:Sybase.exp -Wl,-bnoentry -lc Sybase.o dbdimp.o
-o blib/arch/auto/DBD/Sybase/Sybase.so -L/usr/local/sybase/ds12_5/
OCS-12_5/lib -lintl -ldl -lm

ld: 0711-317 ERROR: Undefined symbol: .ct_dynamic

ld: 0711-317 ERROR: Undefined symbol: .ct_command

ld: 0711-317 ERROR: Undefined symbol: .ct_param

ld: 0711-317 ERROR: Undefined symbol: .cs_convert

ld: 0711-317 ERROR: Undefined symbol: .ct_cancel

ld: 0711-317 ERROR: Undefined symbol: .ct_close

ld: 0711-317 ERROR: Undefined symbol: .cs_diag

ld: 0711-317 ERROR: Undefined symbol: .blk_bind

ld: 0711-317 ERROR: Undefined symbol: .blk_rowxfer

ld: 0711-317 ERROR: Undefined symbol: .ct_results

ld: 0711-317 ERROR: Undefined symbol: .ct_res_info

ld: 0711-317 ERROR: Undefined symbol: .ct_fetch

ld: 0711-317 ERROR: Undefined symbol: .ct_capability

ld: 0711-317 ERROR: Undefined symbol: .ct_send

ld: 0711-317 ERROR: Undefined symbol: .ct_describe

ld: 0711-317 ERROR: Undefined symbol: .ct_cmd_drop

ld: 0711-317 ERROR: Undefined symbol: .blk_done

ld: 0711-317 ERROR: Undefined symbol: .ct_bind

ld: 0711-317 ERROR: Undefined symbol: .cs_dt_info

ld: 0711-317 ERROR: Undefined symbol: .cs_dt_crack

ld: 0711-317 ERROR: Undefined symbol: .ct_options

ld: 0711-317 ERROR: Undefined symbol: .blk_drop

ld: 0711-317 ERROR: Undefined symbol: .blk_alloc

ld: 0711-317 ERROR: Undefined symbol: .blk_props

ld: 0711-317 ERROR: Undefined symbol: .blk_init

ld: 0711-317 ERROR: Undefined symbol: .blk_describe

ld: 0711-317 ERROR: Undefined symbol: .ct_config

ld: 0711-317 ERROR: Undefined symbol: .cs_loc_alloc

ld: 0711-317 ERROR: Undefined symbol: .cs_locale

ld: 0711-317 ERROR: Undefined symbol: .ct_con_alloc

ld: 0711-317 ERROR: Undefined symbol: .ct_con_props

ld: 0711-317 ERROR: Undefined symbol: .ct_connect

ld: 0711-317 ERROR: Undefined symbol: .ct_con_drop

ld: 0711-317 ERROR: Undefined symbol: .ct_cmd_alloc

ld: 0711-317 ERROR: Undefined symbol: .ct_compute_info

ld: 0711-317 ERROR: Undefined symbol: .ct_send_data

ld: 0711-317 ERROR: Undefined symbol: .ct_data_info

ld: 0711-317 ERROR: Undefined symbol: .ct_get_data

ld: 0711-317 ERROR: Undefined symbol: .cs_loc_drop

ld: 0711-317 ERROR: Undefined symbol: .cs_ctx_alloc

ld: 0711-317 ERROR: Undefined symbol: .cs_config

ld: 0711-317 ERROR: Undefined symbol: .ct_init

ld: 0711-317 ERROR: Undefined symbol: .cs_ctx_drop

ld: 0711-317 ERROR: Undefined symbol: .ct_callback

ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.

make: 1254-004 The error code from the last command is 8.

Stop.

.

Relevant Pages

  • Installation Issues
    ... I am new to SYBPERL and need your help to install DBD::sybase in AIX5 unix system. ... The following are my environment variables. ... Sybase implements AutoCommit handling for both its ODBC and JDBC drivers. ... Note (probably harmless): ...
    (perl.dbi.users)
  • Re: sybase -203 error
    ... I found the error code and the error ... A recoverable error occurred while fetching a row. ... I am getting a sybase '-203' error? ... I am calling a stored proc using ct-lib which works fine from the sql ...
    (comp.databases.sybase)
  • Re: trouble loading DBD sybase, 1_07_01
    ... trouble loading DBD sybase, ... To clear an entry please enter 'undef' ... Toute utilisation de ce ... dans l'hypothese ou il aurait ete modifie. ...
    (perl.dbi.users)
  • Re: -1073741819 Error Code returned from dtexec
    ... So this error code as memory serves means Access Denied. ... This could be due to being unable to log in properly to the Sybase or SQL Server. ... I'm getting it when running SSIS packages from a DOS script. ...
    (microsoft.public.sqlserver.dts)
  • trouble loading DBD sybase, 1_07_01
    ... I am trying to load DBD sybase on linux ... I am running a 32 bit version of sybase. ... To clear an entry please enter 'undef' ... Writing login information, including password, to file PWD. ...
    (perl.dbi.users)