I have an application that uses SQL Server 2005 stored procedures as part of the business logic. I'd like to know if it is possible (and what I would require in terms of drivers, etc) to create a linked server to a Dbase 5.0 database and query it from the stored procedure. I cannot import the data to SQL Server because another application uses the Dbase database and we have to have the data in real-time for both applications.
Thanks in advance