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

infodsh@emirates.net.ae ("Infodata Ltd. (Sharjah) U.A.E.") wrote: :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, Whatever you do you have to set up two ODBC connections (two different entries when using the ODBC administrator in the Windows Control Panel). I don't know of any server based ODBC drivers for Novell. If you can't find that you will have to install the Sybase Open Client software (or similar access software from Sybase) and install ODBC on top of that. OpenLink has OpenLink Lite for Sybase that should be able to do this. Then you install a server based ODBC driver on your SCO machine (for best performance and all the other features this gives you) and the proper client software on Windows. (OpenLink Enterprice works for this.) Now you can do regular ODBC connections to both databases. I don't know if NewEra can have two connections open at the same time, but it ought to be able to. If not you can use temporary variables as you suggest. Probably not fast, but it may be workable. You find OpenLink at http://www.openlinksw.com Hope this helps you out. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org