FreeTDS Development Group

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

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