We have a web site that accesses data from many different data sources. All the data sources are set up as system DSN’s. The problem is with one of the DSN’s. The data is physically located on a NT server seperate of the IIS server. The data is all FoxPro free tables. All the DSN’s point to data on a NT server except one. That one is the problem. That particular DSN points to data on a Win95 machine. The DSN keeps losing it’s data path. The only way we have found to keep the DSN working is to run a macro on the server which constantly browses the data location. If this is not done, the ASP page that needs that data will error out because it can’t find the data. The Win95 machine is on the same domain as then NT box. The NT box is mapped to the shared drive of the Win95 machine. We have tried using UNC with the same results. The macro we use to constantly browse the DSN path stops when we lock the server, so we need another alternative. Any Ideas?
