My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform. *** ***

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
 HSODBC release 9 fails with error:
 HSODBC release 10gR1 and 10gR2 fail with the error message:
 DG4ODBC V11.R1 and V11.R2 fail with error code:
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.