Re: spreadsheets access to informix

In article <PHIL.94Nov24101635@mchenry.iisc.demon.co.uk> phil@iisc.demon.co.uk "Philip Shotton" writes: > > Is there some way to connect a spreadsheet product to an Informix database? > > The preferred configurations are: > Informix Online 5.+ on SCO/Unix > spreadsheet on the Unix system with the database or spreadsheet running > on a MacIntosh running system 7. > prefer Excel. > > Does anyone know what pieces are out there? > > Thanks in advance. > > Wingz (from Informix) will do what you want. Wingz is available on the > Mac and maybe on SCO. HyperScript Tools will also do it, but I don't > know what the availability is. > > Wingz uses an Informix add-on called Datalink that connects to > Informix DB using Inet. HST has inbuilt SQL functionality. They are > both pretty good GUI builders, allowing apps to be rapidly built. > > Let me know if you want more info. > > Phil > I did this with Excel on a PC with the following structure (approximate). Note I did it with the SE backend. Server PC ------ -- Operating System (SCO Unix) Operating System (DOS) SCO TCP/IP FTP PC/TCP (PCI and LAN Workplace for DOS did not work **) I-Net (sqlexecd) I-Net PC (Informix daemon running) Windows (waiting for connection) Q+E ODBC driver installed Excel v5.0 and Microsoft Query running This worked fine. Lots of setting up and parameters though. **The reason that PCI and LAN Workplace for DOS (the Novell TCP/IP environment) did not work is that at a horizontal level the TCP/IP stacks are exactly the same (ie between machines), but on a specific machine the TCP/IP stacks might be different (ie on a vertical level). Good luck. -- David H Lipschitz email: david@lipdav.demon.co.uk Orbital Decisions: decision support services to bulk shipping companies The opinions are probably those of my company. I own the company If you don't try, you won't know