We are currently using oracle's transparent gateway to connect to our AS400/DB2 database from oracle 8i. Now we want to do the same for SQL Server. Is there also a gateway that needs to be set up or will SQL Server's Linked Server alone do the trick? As I said our oracle/db2 link is set up and working fine, but I cannot find any useful information on how to set up the SQL Server/DB2 link. I assume if there is a gateway it will be set up on the SQL Server side (Linked server???), but I do not know what needs to be done on the AS400 or SQL Server side for that matter..
Any advice/links/tips will be very much appreciated.