Home » RDBMS Server » Networking and Gateways » Oracle Heteregenous Services (Ortacle 10g and Windows )
Oracle Heteregenous Services [message #447308] Sat, 13 March 2010 08:27 Go to next message
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
Re: Oracle Heteregenous Services [message #447310 is a reply to message #447308] Sat, 13 March 2010 08:31 Go to previous messageGo to next message
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.
Re: Oracle Heteregenous Services [message #447312 is a reply to message #447308] Sat, 13 March 2010 08:33 Go to previous messageGo to next message
aijaz786
Messages: 91
Registered: February 2010
Member
HS_FDS_CONNECT_INFO = MyConn

Can we use multiple dsn sources names for the above parameter?

HS_FDS_CONNECT_INFO = dsn1, dsn2, dsn3, etc.

Re: Oracle Heteregenous Services [message #447313 is a reply to message #447312] Sat, 13 March 2010 08:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can we use multiple dsn sources names for the above parameter?
Use what works & does not throw error
Previous Topic: which listener is needed to access ASM database
Next Topic: Connect time fail over
Goto Forum:
  


Current Time: Thu Mar 28 13:25:25 CDT 2024