connecting to Multiple SQLServer databases from Oracle (Unix) vi a ODBC for UNIX

connecting to Multiple SQLServer databases from Oracle (Unix) vi a ODBC for UNIX

 

  

Hi all!

I have to connect from an Oracle database (running on a Sun box) to several
SQLServer databases (running on a single NT box) - and not the opposite- ;-)

So I installed the ODBC for Unix (Merant) which works fine to connect to a
single SQLServer database (one SQLServer entry in odbc.ini file)
Trouble is that it does not work anymore when I added a second SQLServer
entry in the odbc.ini file (although corresponding entries were created in
tnsnames.ora and listener.ora)

Little bit difficult to understand, but those of you who already tried will
probably understand what I mean

Thanks for any suggestion

Philippe
Oracle LazyDBA home page