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 laterOracle 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 |