Skip to Content.
Sympa Menu

freetds - [freetds] Missing ODBC functions: SQLDescribeParam, SQLExtendedFetch

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Pan, Suixiong" <sxpan AT dcss.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Missing ODBC functions: SQLDescribeParam, SQLExtendedFetch
  • Date: Mon, 17 Jan 2005 10:08:23 -0600

It appears that these functions are still missing from the ODBC part of the
library. I am trying to use FreeTDS (currently release, 0.64) with Oracle's
generic connectivity on the Solaris platform to connect to a Sql Server 2000
db. Is this the problem I am experiencing? If so, are these functions
planned for a future release? As it is, I can not get FreeTDS to work with
Oracle.



The following is a trace from Oracle:



> Oracle Corporation --- MONDAY JAN 17 2005 07:11:49.061

>

> Version 9.2.0.4.0

>

> hoagprd (2): ; hoagprd Entered.

> (0): ; [Generic Connectivity Using ODBC] version: 3.3.00.00.0034

> (0): ; Class version: 125

> hoagprd (2): ; hoagprd Exited with retcode = 0.

> hoainit (3): ; hoainit Entered.

> (0): ; connect string is: defTdpName=riskddx;SYNTAX=(ORACLE8_HOA,

> BASED_ON=ORACLE8, IDENTIFIER_QUOTE_CHAR="",

> CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj>

> <binding>

> <datasources>

> <datasource name='riskddx' type='GENERIC_ODBC_FOR_HS'

> connect='riskddx'>

> <driverProperties/></datasource></datasources><remoteMachines/><enviro

> nment> <misc year2000Policy='-1' consumerApi='1'

> sessionBehavior='4'/><queryProcessor

> parserDepth='2000' noInsertParameterization='true'
noThreadedReadAhead='true'

> noCommandReuse='true'/><debug driverTrace='true'

> generalTrace='true'/></environment></binding></navobj>

> ORACLE GENERIC GATEWAY Log File Started at 17-Jan-05 07:11:49 hoainit

> (3): ; hoainit Exited with retcode = 0.

> hoalgon (7): ; hoalgon Entered. name = RISKDDXDEVUSER.

> 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 MON JAN 17 07:11:49 2005.



Thanks in advance for any help.



Suixiong Pan




  • [freetds] Missing ODBC functions: SQLDescribeParam, SQLExtendedFetch, Pan, Suixiong, 01/17/2005

Archive powered by MHonArc 2.6.24.

Top of Page