Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Wei Jiang <impc75 AT yahoo.com.cn>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] I can not use freeTDS for Oracle HS
  • Date: Fri, 17 Jun 2005 11:01:07 +0800 (CST)

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.





___________________________________________________________
雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱
http://cn.mail.yahoo.com/?id=77071





Archive powered by MHonArc 2.6.24.

Top of Page