FreeTDS Development Group

["Pan, Suixiong" <sxpan AT dcss.com>]

Okay, I've installed unixODBC, then FreeTDS.  I've reconfigure Oracle to
load the libodbc.so driver from unixodbc.  Unfortunately, I still get the
same errors!  Here's a trace from oracle:

ORACLE GENERIC GATEWAY Log File Started at 19-Jan-05 15:34:27 hoainit (3): ;
hoainit Exited with retcode = 0.
hoalgon (7): ; hoalgon Entered. name = DWIMS.
sysbase.c (675): ; ld.so.1: hsodbcriskddx: fatal: SQLDescribeParam: can't
find symbol DB_ODBC_INTERFACE (713): ; [C077] Could not find symbol
'SQLDescribeParam' in dynamic library DB_ODBC_INTERFACE (717): ; [C079]
Failed to load dynamic library '/usr/local/lib/libtdsodbc.so'
DB_ODBC_INTERFACE (722): ; [C077] Could not find symbol 'SQLDescribeParam'
in dynamic library sysbase.c (675): ; ld.so.1: hsodbcriskddx: fatal:
SQLExtendedFetch: can't find symbol DB_ODBC_INTERFACE (713): ; [C077] Could
not find symbol 'SQLExtendedFetch' in dynamic library DB_ODBC_INTERFACE
(717): ; [C079] Failed to load dynamic library
'/usr/local/lib/libtdsodbc.so'
DB_ODBC_INTERFACE (722): ; [C077] Could not find symbol 'SQLExtendedFetch'
in dynamic library
DRV_InitTdp: DB_ODBC_INTERFACE (713): ; [C077] Could not find symbol
'SQLDescribeParam' in dynamic library DB_ODBC_INTERFACE (717): ; [C079]
Failed to load dynamic library '/usr/local/lib/libtdsodbc.so'
DB_ODBC_INTERFACE
(713): ; [C077] Could not find symbol 'SQLExtendedFetch' in dynamic library
DB_ODBC_INTERFACE (717): ; [C079] Failed to load dynamic library
'/usr/local/lib/libtdsodbc.so'

nvRETURN (./drv_bind.c 201): -2220
nvRETURN (./nav_bind.c 456): -2220
hoalgon (7): ; hoalgon Exited with retcode = 28500.
hoaexit (6): ; hoaexit Entered.
hoaexit (6): ; hoaexit Exited with retcode = 0.
 (0): ; Closing log file at WED JAN 19 15:34:27 2005.
-----------
The curious thing is, oracle seems to be trying to load libtdsodbc.so
instead of libodbc.so.  Is this what's expected, or is it an indication that
the oracle setup isn't correct?  I shouldn't need to restart the whole
oracle db to get this to work, right?  FYI, I have restarted the listeners
for oracle.

Thanks!
Pan

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: Monday, January 17, 2005 1:18 PM
To: FreeTDS Development Group
Subject: RE: [freetds] Missing ODBC functions: SQLDescribeParam, SQLExtend
edFetch

Il giorno lun, 17-01-2005 alle 10:18 -0600, Pan, Suixiong ha scritto:
> So what you are saying is by using either iODBC or unixODBC, it would
> provide these functions, and this should work?  I'll give it a try.  
> 
> Btw, Oracle states that a DM is not required for generic connectivity on
> Unix platforms, just an ODBC driver.  Any thoughts on that?
> 
> Thanks,
> Pan
> 

You can do the same under windows... however DM can do additional
things:
- backward compatibility. It can emulate some function using others. For
example SQLExtendedFetch it's deprecated in ODBC3 and implemented in DM
for compatibility. FreeTDS it's an ODBC3 driver, it can provide
functions for backward compatibility but not required.
- logging. Very useful.
- parameter checking. More safety

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds