Skip to Content.
Sympa Menu

freetds - RE: [freetds] Generic Connectivity Using ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Зверев Виталий Борисович <VZverev AT genesis.spb.ru>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Generic Connectivity Using ODBC
  • Date: Tue, 3 May 2005 14:02:01 +0400

Hi, Daron.
Listener is trying to launch the heterogeneous agent but
1) heterogeneous agent may be absent (not installed)
2) pointed into wrong ORACLE_HOME via listener.ora
3) has wrong permissions

You could try to check it:

bash-2.03$ cd $ORACLE_HOME/rdbms/lib
bash-2.03$ make -f ins_rdbms.mk ihsodbc

- Linking hsodbc agent
rm -f /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
/usr/ccs/bin/ld -o /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
-L/home2/u01/app/oracle/product/9.2/rdbms/lib/
-L/home2/u01/app/oracle/product/9.2/lib/ -dy
/home2/u01/app/oracle/product/9.2/lib/WS6U1/crti.o
/home2/u01/app/oracle/product/9.2/lib/WS6U1/crt1.o
/home2/u01/app/oracle/product/9.2/hs/lib/hsodbc.o
/home2/u01/app/oracle/product/9.2/rdbms/lib/defopt.o
/home2/u01/app/oracle/product/9.2/rdbms/lib/homts.o
-L/home2/u01/app/oracle/product/9.2/lib/ -lnavhoa -lhsnav -lhsbase
-lagtsh -lpls9 -lplp9 -lthread -lclntsh -lnls9 -lcore9 -lnls9 -lcore9
-lnls9 -lxml9 -lcore9 -lunls9 -lnls9
/home2/u01/app/oracle/product/9.2/lib/libgeneric9.a `cat
/home2/u01/app/oracle/product/9.2/lib/sysliblist` -R
/opt/SUNWcluster/lib:/home2/u01/app/oracle/product/9.2/lib -Y
P,:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib -Qy -lc -laio -lposix4
-lkstat -lm /home2/u01/app/oracle/product/9.2/lib/WS6U1/crtn.o -lvsn9
mv -f /home2/u01/app/oracle/product/9.2/bin/hsodbc
/home2/u01/app/oracle/product/9.2/bin/hsodbcO
mv /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
/home2/u01/app/oracle/product/9.2/bin/hsodbc
chmod 751 /home2/u01/app/oracle/product/9.2/bin/hsodbc
bash-2.03$

bash-2.03$ /home2/u01/app/oracle/product/9.2/bin/hsodbc

Oracle Corporation --- TUESDAY MAY 03 2005 13:59:10.572

Heterogeneous Agent Release 9.2.0.5.0 - Production Built with
Driver for ODBC

Sincerely yours.

------------------------------------------------------------
Vitaly Zverev, Oracle Applications DBA,
Genesis Ltd., St.Petersburg, Russia
>>>>>> Tel : +7(812) 329-5689 <<<<<<
>>>>>>>> http://www.gen.ru <<<<<<<<



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Daron Daron
Sent: Tuesday, May 03, 2005 12:57 PM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Generic Connectivity Using ODBC


Hi,
I have oracle 9i on linux redhat 9, and the MSSQL is runing on window
2003. I try with no luck and having the same problems. Hope can get some
hints from you guys.

TNS:01201 : listener cannot find executable
/opt/oracle/product/9.2.0/bin/hsodbc for SID DBSTAF.
Listener failed to start


initDBSTAF.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = DbStaf
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini


Thanks

Daron

_________________________________________________________________
Block pop-up ads with MSN Toolbar. http://toolbar.msn.com.my/

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page