Using Informix as a Linked Server in SQL 7

[joekurtz]

MS has several samples of creating views of other data sources from within SQL 7. I have a customer who would like me to do the same thing using an Informix database which resides on their UNIX box. I have the ODBC for the Informix connection installed and tested. I was able to create the linked server object and the login that relates to it. The problems start when I try to create the views of the data. I end up with errors stating that files related to Informix (os.iem, etc) could not be found. I have supplied the OS with a full path statement to attempt to fix this. The OS reports back the proper path but I still get the errors. SQL 7 is installed on a Windows 2000 server and has been running for some time now with no problems.

Any ideas on how to fix this or where to turn to for more information would be a great help.

Thanks Joe Kurtz
[sig][/sig]