NE w/ODBC to TCP/IP & IPX/SPX db

Posted in 1996

"Infodata Ltd. Sharjah U.A.E." — 14 Dec 1996 02:03:24 -0500 — source: Informix-list mailing list archive (1991-1998)

Dear All, I have an Informix 5.x database on SCO-Unix (TCP/IP) and a Sybase database on Novell server (IPX/SPX). I want to connect I-NewEra over ODBC to both the databases simultaneously. E.g. Select from Ix_db insert into Syb_db. If this is not feasible, can I first connect to Ix_db over TCP/IP hold the data in temp vars. and then connect to Syb_db over IPX/SPX and continue processing? As there are two protocols involved, I am confused how ODBC drivers need to be configured. Appreciate all your views. Thanks in advance, Dilip Kikla