Error Installing DBD::ODBC on AIX 5.2

peacemaker1820 has asked for the wisdom of the Perl Monks concerning the following question:

Hi all,

I am having problems installing DBD::ODBC on AIX 5.2. I've set/export all the necessary @ENV variables.

Here is the output of my install:

$ perl -MCPAN -e 'install DBD::ODBC'
CPAN: Storable loaded ok
Going to read /app/mark/.cpan/Metadata
  Database was generated on Mon, 26 Nov 2007 15:36:58 GMT
LWP not available
CPAN: Net::FTP loaded ok
Fetching with Net::FTP:
...
...
...
cc_r -c -I/usr/local/easysoft/unixODBC/include  -I. -I/usr/opt/perl5/l
+ib /site_perl/5.8.0/aix-thread-multi/auto/DBI  -D_ALL_SOURCE -D_ANSI_
+C_SOURCE -D_PO SIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_D
+LOPEN -DNEED_PTHREAD_INIT
-q32 -D_LARGE_FILES -qlonglong -O    -DVERSION=\"1.14\"  -DXS_VERSION=
+\"1.14\"
"-I/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE"  -I/usr/local/easys
+oft/unixOD BC/include unicode_helper.c
1506-507 (W) No licenses available. Contact your program supplier to a
+dd additio nal users. Compilation will proceed shortly.
"unicode_helper.c", line 341.26: 1506-356 (W) Compilation unit is empt
+y.
Running Mkbootstrap for DBD::ODBC ()
        chmod 644 ODBC.bs
        rm -f blib/arch/auto/DBD/ODBC/ODBC.so
        LD_RUN_PATH="/usr/local/easysoft/unixODBC/lib" ld  -bhalt:4 -b
+M:SRE -bI:
/usr/opt/perl5/lib/5.8.0/aix-thread-multi/CORE/perl.exp -bE:ODBC.exp -
+bnoentry - lpthreads -lc_r ConvertUTF.o  ODBC.o  dbdimp.o  unicode_he
+lper.o  -o blib/arch/a
uto/DBD/ODBC/ODBC.so      -L/usr/local/easysoft/unixODBC/lib -lodbc
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocHandle
ld: 0711-317 ERROR: Undefined symbol: .SQLPrimaryKeys
ld: 0711-317 ERROR: Undefined symbol: .SQLFreeHandle
ld: 0711-317 ERROR: Undefined symbol: .SQLRowCount
ld: 0711-317 ERROR: Undefined symbol: .SQLSetStmtAttr
ld: 0711-317 ERROR: Undefined symbol: .SQLDescribeParam
ld: 0711-317 ERROR: Undefined symbol: .SQLBindParameter
ld: 0711-317 ERROR: Undefined symbol: .SQLNumResultCols
ld: 0711-317 ERROR: Undefined symbol: .SQLMoreResults
ld: 0711-317 ERROR: Undefined symbol: .SQLDescribeCol
ld: 0711-317 ERROR: Undefined symbol: .SQLColAttributes
ld: 0711-317 ERROR: Undefined symbol: .SQLBindCol
ld: 0711-317 ERROR: Undefined symbol: .SQLError
ld: 0711-317 ERROR: Undefined symbol: .SQLExecDirect
ld: 0711-317 ERROR: Undefined symbol: .SQLForeignKeys
ld: 0711-317 ERROR: Undefined symbol: .SQLSpecialColumns
ld: 0711-317 ERROR: Undefined symbol: .SQLStatistics
ld: 0711-317 ERROR: Undefined symbol: .SQLTables
ld: 0711-317 ERROR: Undefined symbol: .SQLColumns
ld: 0711-317 ERROR: Undefined symbol: .SQLCancel
ld: 0711-317 ERROR: Undefined symbol: .SQLGetTypeInfo
ld: 0711-317 ERROR: Undefined symbol: .SQLGetInfo
ld: 0711-317 ERROR: Undefined symbol: .SQLGetCursorName
ld: 0711-317 ERROR: Undefined symbol: .SQLGetData
ld: 0711-317 ERROR: Undefined symbol: .SQLFreeStmt
ld: 0711-317 ERROR: Undefined symbol: .SQLFetch
ld: 0711-317 ERROR: Undefined symbol: .SQLExecute
ld: 0711-317 ERROR: Undefined symbol: .SQLParamData
ld: 0711-317 ERROR: Undefined symbol: .SQLPutData
ld: 0711-317 ERROR: Undefined symbol: .SQLPrepare
ld: 0711-317 ERROR: Undefined symbol: .SQLGetConnectOption
ld: 0711-317 ERROR: Undefined symbol: .SQLSetConnectOption
ld: 0711-317 ERROR: Undefined symbol: .SQLDisconnect
ld: 0711-317 ERROR: Undefined symbol: .SQLEndTran
ld: 0711-317 ERROR: Undefined symbol: .SQLSetEnvAttr
ld: 0711-317 ERROR: Undefined symbol: .SQLDriverConnect
ld: 0711-317 ERROR: Undefined symbol: .SQLConnect
ld: 0711-317 ERROR: Undefined symbol: .SQLGetFunctions
ld: 0711-317 ERROR: Undefined symbol: .SQLSetConnectAttr
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocEnv
ld: 0711-317 ERROR: Undefined symbol: .SQLDataSources
ld: 0711-317 ERROR: Undefined symbol: .SQLFreeEnv
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more info
+rmation.
make: 1254-004 The error code from the last command is 8.


Stop.
  /bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
[download]

Thanks for your input.

No Peace Without War!

Comment on Error Installing DBD::ODBC on AIX 5.2 Download Code

Replies are listed 'Best First'.
Re: Error Installing DBD::ODBC on AIX 5.2 by KurtSchwind (Chaplain) on Nov 27, 2007 at 21:39 UTC
It certainly looks like you are missing a library. Could you please post what is in "unicode_helper.c", line 341.26 because that looks like something else. -- I used to drive a Heisenbergmobile, but every time I looked at the speedometer, I got lost.	[reply]
Re^2: Error Installing DBD::ODBC on AIX 5.2 by peacemaker1820 (Pilgrim) on Nov 30, 2007 at 15:50 UTC
Thanks for trying to help me out, but I fixed the problem. Apparently, the SQL Server driver on unix that I installed from easysoft was a 64bit and my perl on AIX 5.2 was a 32bit application. All I had to do was reinstall a 32bit SQL Server Driver from easysoft and force install DBD::ODBC. Worked like a charm :)! No Peace* Without War!*	[reply]


go ahead... be a heretic
	PerlMonks