[unixODBC-support] Make error - Solaris 10

Randy W Magaw rmagaw at wlgore.com
Fri Jun 5 16:40:11 BST 2009


Thanks for the response,  2.2.14p-2 still gave the same make error, using 
2.2.15pre resolved the make error.

I'm trying to use Oracle's dg4odbc with FreeTDS driver to query SQLServer 
db's within Oracle.

In trying to test the setup, dg4odbc is throwing an error.

Use of tsql and isql work fine.

I may not be compiling with the correct flags ?  I'm using gcc4 of gcc. 
Oracle docs say drivers and driver manager should be 64-bit for dg4odbc, 
some other support sites still refer to 32-bit.  I'd expect an ELF type 
error.

This is the dg4odbc trace ->

Entered hgolofn at 2009/06/05-11:08:26
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned 
"/apps/unixODBC64/lib/libodbc.so"
Entered hgolofns at 2009/06/05-11:08:26
 libname=/apps/unixODBC64/lib/libodbc.so, funcname=SQLAllocHandle
 hoaerr:28500
Exiting hgolofns at 2009/06/05-11:08:26
Failed to load ODBC library symbol: 
/apps/unixODBC64/lib/libodbc.so(SQLAllocHandle)
Exiting hgolofn, rc=28500 at 2009/06/05-11:08:26
Exiting hgoinit, rc=28500 at 2009/06/05-11:08:26 with error ptr 
FILE:hgoinit.c LINE:282 ID:Loading OD
BC aray of function ptrs
Entered hgoexit at 2009/06/05-11:08:26

dg4odbs init file ->

HS_DB_NAME = hsconnect
HS_DB_DOMAIN = xxxx
HS_FDS_CONNECT_INFO = PB0SQL00
HS_FDS_SHAREABLE_NAME = /apps/unixODBC64/lib/libodbc.so
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_FDS_TRACE_LEVEL=4
#
# Environment variables required
#
set ODBCINI=/apps/unixODBC64/etc/odbc.ini
set ODBCINSTINI=/apps/unixODBC64/etc/odbcinst.ini
set 
LD_LIBRARY_PATH=/apps/FreeTDS64/lib:/apps/unixODBC64/lib:/apps/oracle/product/11.1.0.6/db/lib
set PATH=/apps/FreeTDS64/bin:/apps/unixODBC64/bin

The SQLAllocateHandle appears to be in place ->

SymFind - Find Symbol <SQLAllocHandle> in <**>.a, .o, .so
------------------------------------------------------
Command:         /apps/oracle/product/11.1.0.6/db/bin/symfind -c -i -v 
SQLAllocHandle
Local Directory: /apps/unixODBC64
Output File:     (none)
Note:            I do not traverse symbolic links
                 Use '-v' option to show any symbolic links

Locating Archive and Object files ...
Processing: ./lib/libodbc.so ...  << Symbolic Link
[81]    |     41052|    3740|FUNC |LOCL |2    |13     |__SQLAllocHandle
[2759]  |     44792|      28|FUNC |GLOB |0    |13     |SQLAllocHandle
[425]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandle.c
[2606]  |     44820|      84|FUNC |GLOB |0    |13     |SQLAllocHandleStd
[439]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandleStd.c
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libodbc.so
Processing: ./lib/libodbcinst.so.1 ...  << Symbolic Link
Processing: ./lib/libodbccr.so ...  << Symbolic Link
[138]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandle.c
[141]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandleStd.c
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libodbccr.so
Processing: ./lib/libodbccr.so.1 ...  << Symbolic Link
[138]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandle.c
[141]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandleStd.c
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libodbccr.so.1
Processing: ./lib/libodbc.so.1 ...  << Symbolic Link
[81]    |     41052|    3740|FUNC |LOCL |2    |13     |__SQLAllocHandle
[2759]  |     44792|      28|FUNC |GLOB |0    |13     |SQLAllocHandle
[425]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandle.c
[2606]  |     44820|      84|FUNC |GLOB |0    |13     |SQLAllocHandleStd
[439]   |         0|       0|FILE |LOCL |0    |ABS    |SQLAllocHandleStd.c
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libodbc.so.1

Processing: ./lib/libodbcinst.so ...  << Symbolic Link


more odbcinst.ini
[TDS]
Description = FreeTDS unixODBC
Driver = /apps/FreeTDS64/lib/libtdsodbc.so


---------------------------------------------------------------------------------------------

Please Advise






Nick Gorham <nick at lurcher.org> 
Sent by: unixodbc-support-bounces at mailman.unixodbc.org
06/02/2009 05:47 PM
Please respond to
Support for the unixODBC project <unixodbc-support at mailman.unixodbc.org>


To
Support for the unixODBC project <unixodbc-support at mailman.unixodbc.org>
cc

Subject
Re: [unixODBC-support] Make error - Solaris 10






Randy W Magaw wrote:
>
> Hello,
>
> I've been using unixodbc 2.2.12 on Solaris 10 with Oracle 10g for the 
> past 2 years.  I'm trying to install 2.2.14 on Solaris 10 for use in a 
> 11g database.  The ./configure --prefix=/apps/unixODBC64 works fine 
> but the make is failing ->
>
Hi,

either try the 2,2,14p-2 thats on the ftp.unixodbc.org server, the 
2,2,15pre pre-release on on the same site, or given you want to use it 
with oracle not postgres, add --enable-drivers=no to the configure line.

-- 
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090605/9eeb3a5c/attachment.html>


More information about the unixODBC-support mailing list