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

Your network can run multiple protocols at the same time i.e TCP/IP and IPX/SPX over the Ethernet LAN. However the client needs to be set up to listen for both the protocols, once that is done you could connect upto both databases from your client. However, I do not know about simultaneous connections to the database, that I think would have to be configured in I-NewEra over the ODBC driver and would depend on the capability of the ODBC Driver and I-NewEra. But if you can connect to them indepedantly I would think that you will be able to store stuff in temp variables and push them into the second database.... Sham Vaidya smvaidya@auto.rockwell.com In article <593n5q$h25@cssun.mathcs.emory.edu>, infodsh@emirates.net.ae says... > >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 > > > >