Setup: I currently have SQL 2000 and Cache 4.01 on one server (Mars). I have set up a linked server in SQL 2000 (Cache_Info) via the InterSystems ODBC connection. Here is and example of a query that works:
select top 10 * from Cache_Info..SqlUser.ClientNames This query will return the top ten values in this table... great. Problem: I have another server (Pluto) that has SQL 2000 on it. I want to access the Cache DB on Mars via the InterSystems ODBC connection, just like on the server described above. I have set up Linked Server (Cache_Info_Pluto) via the InterSystems ODBC connection using the IP address of Mars (where the Cache DB is located) and check the Test Connection button. The test comes back successful. When I try to execute the following query on Pluto: select top 10 * from Cache_Info_Pluto..SqlUser.ClientNames I get the following error message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'CrystalServer.ClosedIntegratorBase' reported an error. [OLE/DB provider returned message: Cannot load data source: DEF] [OLE/DB provider returned message: DataSource file (*.IDS file) directory not set] [OLE/DB provider returned message: DataSource file (*.IDS file) directory not set] [OLE/DB provider returned message: The system cannot find the file specified. Any help on this issue would be greatly appreciated, -p
