Hello,
I'm using oracle 12c and I managed to install and configure database gateway for ODBC
Now I would need to connect to multiple MS SQL DB and to do so it seems that I need to install a database gateway instance for each MS SQL SRV as I can see in this doc at pg 98:
http://www-css.fnal.gov/dsg/external/oracle_dcm/v11.2.0.2/gateways.112/e12013.pdf
What I don't understand is how to install multiple instances of DB Gateway, in the doc they say:
"Choose One System ID for Each SQL Server Database A separate instance of the gateway is needed for each SQL Server database. Each instance needs its own gateway System ID (SID)."
I tried to run the DB GW installer, but if I install it again in the same directory where I have installed before, it just overwrite the previous installation, if I change installation destination, the previous dblink doesn't work anymore
Does anyone have experience on installing and configuring multiple database gateway for odbc ?
Thanks a lot