OraFAQ Forum: Networking and Gateways » Oracle Heteregenous Services

Home » RDBMS Server » Networking and Gateways » Oracle Heteregenous Services (Ortacle 10g and Windows )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Heteregenous Services [message #447308]

Sat, 13 March 2010 08:27

aijaz786
Messages: 91
Registered: February 2010

Member

I have following file setup for Oracle heteregenous services for MS Access. I also need to add one more dsn for MS Excel.

# 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 = MyConn
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Note: MyConn is for MS Access that I cretaed.

Can we use like this

HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.

I searched net and documentation but I did not find any clue.

Please advice
Thanks

Report message to a moderator

Re: Oracle Heteregenous Services [message #447310 is a reply to message #447308]

Sat, 13 March 2010 08:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I searched net and documentation but I did not find any clue.

Perhaps that is because Excel is not a SERVER & can not accept connection from a client.

Report message to a moderator