Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Error Installing DBD::ODBC on AIX 5.2

by peacemaker1820 (Pilgrim)
on Nov 27, 2007 at 21:07 UTC ( #653368=perlquestion: print w/replies, xml ) Need Help??

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


Thanks for your input.

No Peace Without War!

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.
      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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://653368]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (5)
As of 2020-11-27 08:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?