In a program I have written I am using SQLEXEC to query two SQLservers. One is local to me, one is at another facility. Both SQLservers are in the same domain. When the exe queries my local server I get data. When the exe queries the remote server no data is received. If I run this exe as a foxpro exe sitting on a Novell server it works fine and data comes from both sqlservers, it is when the program is run as a .dll or an out-of-process exe from an IIS server that we loose the data. The IIS server is not in the domain with the SQLservers. It would make sense to me if the IIS server lost data from both SQLservers, but not losing it from one.

The only complicating factor may be that the remote SQLserver is on a VPN which is established through a PIX firewall. However to test the VPN we have created a data connection in Interdev and we have no problems seeing the remote SQLserver and browsing it's tables.

The IIS server does have an ODBC connection to each sqlserver. We are using logon and password authentication to the SQLservers, not trusted connections.