[unixODBC-support] problem with undefined symbols

Breazeale, Joel L - Eagan, MN - Contractor Joel.L.Breazeale at usps.gov
Mon Jul 7 17:34:11 BST 2014


Folks,

I am using Perl 5.10.0-64.67.52, perl-DBD-ODBC 1.17-1.15, unixODBC 2.2.12-198.17 on SUSE Enterprise 11.

I have set the OOBCSYSINI environment variable to ~/.odbcsysinst and have the following files in that directory:

odbc.ini:
Driver=SQL Server
Description=ESMWI Database
Database=ESMWI
Server=ESMHOST
Port=1433
User=USER
Password=PW
Trace=Yes
TraceFile=/tmp/ESMWI.log

edbcinst.ini:
[SQL Server]
Description=Microsoft SQL Server
Driver=/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so
FileUsage=1
CommLog=1

These are the two problems I'm seeing when trying to connect to the ESMWI database:

>From Perl:

> updpconfig.pl -he
DBI connect('ESMWI','USER',...) failed: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL-IM004) at /home/k5ycc0/bin/updpconfig.pl line 86
>

>From isql:

> isql -v ESMWI
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so' : file not found
[ISQL]ERROR: Could not SQLConnect
>

I've been looking around a lot for the solution to these two problems and have seen a lot, but nothing on my side parallels the problems I've seen so far.  However, I did find one thing...

If you look at the following output you'll see a bunch of undefined symbols:

> ldd --data-relocs --unused --verbose --function-relocs /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: PL_no_modify (continued)
undefined symbol: PL_no_modify  (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: PL_memory_wrap (continued)
undefined symbol: PL_memory_wrap        (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_hv_iterinit (continued)
undefined symbol: Perl_hv_iterinit      (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_mg_get (continued)
. . .
undefined symbol: Perl_markstack_grow   (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_newRV (continued)
undefined symbol: Perl_newRV    (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_sv_backoff (continued)
undefined symbol: Perl_sv_backoff       (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_dowantarray (continued)
undefined symbol: Perl_dowantarray      (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
      6413:     /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so: error: symbol lookup error: undefined symbol: Perl_sv_2pv_flags (continued)
undefined symbol: Perl_sv_2pv_flags     (/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so)
Unused direct dependencies:

>

Can any of you give me a roadmap on how to resolve my Perl connection issue using the evidence presented?

Thank you!

--Joel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20140707/082122b6/attachment-0001.html>


More information about the unixODBC-support mailing list