Hi,

Look at the note:231997.1 and don't forget

HS_FDS_CONNECT_INFO="SQLSERVER\\instance2.Northwind" with two "\\"


Cordialy

TL




[Email Address Removed] 11:50


Pour : "LazyDBA.com Discussion" <[Email Address Removed] cc :
Objet : SQL Server connection from Oracle Proc'


Hi all

I have a requirement to connect to a SQL server database from within an
Oracle procedure.

After reviewing the Oracle docs, it seems there are gateway products,
which may/may not require additional software e.g. agents.

Has anyone achieved this? Any further ideas/thoughts?

Many thanks Martin



--

------------------------------------------------------------------------------
HBOS plc, Registered in Scotland No. SC218813. Registered Office: The
Mound, Edinburgh EH1 1YZ. HBOS plc is a holding company, subsidiaries of
which are regulated by the Financial Services Authority.
==============================================================================


--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page