Skip to Content.
Sympa Menu

freetds - RE: [freetds] I can not use freeTDS for Oracle HS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] I can not use freeTDS for Oracle HS
  • Date: Fri, 17 Jun 2005 08:18:09 +0200

>
> I installed unixODBC and freeTDS to connect a SQL
> Server 2000, and test the connection with tsql and
> isql, both are success.
> Then I configured Oracle HS by alter file initHSCWA,
> tnsnames.ora and listener.ora, every is ok. But when I
> run "select * from record@hscwa;" I got error:
>
> select count(d_time) from record@hscwa
> *
> 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 (713): ; [C077]
> Could not find symbol 'SQLDescribeParam' in dynamic
> library
> DB_ODBC_INTERFACE (717): ; [C079] Failed to load
> dynamic library
> '/usr/local/freetds/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/freetds/lib/libtdsodbc.so'
> ORA-02063: preceding 5 lines from HSCWA
>
> My OS is Sun Solaris 8, oracle is 9.2.0.3, if the the
> problem is ODBC version? Which freeTDS and unixODBC
> shell I use?
> Thank you very much.
>

You must use a DM to make HS happy.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page