Re: two databases -- foreign views

Posted in 2003

Zork Adi — 5 Aug 2003 20:32:32 -0700 — source: Usenet: comp.databases.informix

Rob Wilson <rob_wilson@ameritech.net> wrote in message news:<b3QXa.344$Ih1.309090@newssrv26.news.prodigy.com>... > I am not sure about for SQL server but Informix has the Informix > Enterprise Gateway Manager: > > http://www-3.ibm.com/software/data/informix/tools/egm/ > > It can use ODBC drivers, so as long as you have one to access SQL server > you shouldn't have any problems. Once set up it makes the SQL server > database look like an Informix database (it has an entry in sqlhosts). > You can then create views on it if you wish. > Thanks Rob! This looks very promising, I'll take a look at it. > I am not sure what you are trying to accomplish with views of Informix > tables in the SQL server database but you may be able to just create the > tables in SQL server and have views of them in Informix. Z.