HSODBC/DG4ODBC Using FreeTDS ODBC Fails with Missing Symbol SQLDescribeParam or SQLExtendedFetch (Doc ID 393354.1)

Last updated on SEPTEMBER 26, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2010***
***Checked for relevance on 25-Sep-2012***

Symptoms

HSODBC release 9 fails with error:

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][C077] Could not find symbol
'SQLDescribeParam' in dynamic library
[C079] Failed to load dynamic library '/usr/local/lib/libtdsodbc.so'
ORA-02063: preceding 3 lines from HSODBC

HSODBC release 10gR1 and 10gR2 fail with the error message:

'ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE (718): ; [C077]
Could not find symbol 'SQLDescribeParam' in dynamic library
DB_ODBC_INTERFACE (722): ; [C079] Failed to load dynamic library
'/home/odbc/FreeTDS_063/lib/libtdsodbc.so'
DB_ODBC_INTERFACE (718): ; [C077] Could not find symbol 'SQLExtendedFetch' in
dynamic library
DB_ODBC_INTERFACE (722): ; [C079] Failed to load dynamic library
'/home/odbc/FreeTDS_063/lib/libtdsodbc.so'
ORA-02063: preceding 5 lines from FREETDS

 

DG4ODBC V11.R1 and V11.R2 fail with error code:

Entered hgolofns at 2009/06/10-21:21:37
hoaerr:28500
Exiting hgolofns at 2009/06/10-21:21:37
Failed to load ODBC library symbol: /usr/local/freetds/lib/libtdsodbc.so(SQLDescribeParam)
Exiting hgolofn, rc=28500 at 2009/06/10-21:21:37
Exiting hgoinit, rc=28500 at 2009/06/10-21:21:37 with error ptr FILE:hgoinit.c LINE:282
FUNCTION:hgoinit() ID:Loading ODBC aray of function ptrs
Entered hgoexit at 2009/06/10-21:21:37

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms