Re: ODBC with Oracle and Informix on the same server.
Posted in 1993
In article <2dmv1l$fem@galileo.polito.it> badella@polec1.polito.it (enrico badella (L.R.)) writes: > >I have a server with both Oracle 6.x and Informix SE and I would like to >access data from Visual C++ and Visual Basic applications ... cost of installing SQL-Net on all would be outrageous If you've experience with socket programming, you could write a client-server application. Write a server that listens on a TCP/IP socket for connections, processes messages, does the database access and returns the results over the connection. The client PC's would then only have to have TCP/IP on them (which I assume they have anyway since Informix's I-NET and SQL*NET from Oracle require them). This is more work, but most economical in dollars/pounds/lira, as well as in PC memory. We have had trouble trying to fit TCP/IP, INET and ODBC in the same machine and have any room left for an application. --- Jim Burks jburks@promus.com Database Administrator