ice@wang.com (Fredrik Nyman) (07/03/90)
I'm about to set up a simple database on a SCO Unix box. The background: The Unix box resides on a small TCP/IP network with several different operating systems. I would like to be able to communicate with the database from all other machines on the network in a simple way, pretty much like SMTP: On a client (e.g. a DOS PC), the user would like to find out what phone number Bob Jones has. He would then type "query phone Bob Jones", where query is a small program which opens a TCP connection to port NN on the Unix box and translates the user's request to SQL. (select name, phone from personnel where name = 'Bob Jones'). On the Unix box, another program (daemon) that listens on port NN would accept the query, look it up in the database and send the output back to the client. Does anyone use a setup similar to this? How does it work in reality? Does any mainstream Unix DBMS (like Oracle, Ingres, Sybase...) come with a daemon which could do this or will I have to write my own program for that? Any information would be greatly appreciated. -- Disclaimer: Wang doesn't care about my opinions, so why should you? Internet: <ice@wang.COM> <ice@emil.csd.uu.se> BITNET: <ice@DRYCAS> <ice@SEARN> <ice@SEQZ51> (in order of preference) USnail: Wang Labs, Inc., M/S 019-490, One Industrial Ave., Lowell, MA 01851