Creating A Linked Server To Dbase 5.0 Database

  • 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

  • I believe you can as long as you are connecting using an ODBC.

    "We never plan to Fail, We just fail to plan":)

  • Got a way. Created a DSN then a linked server pointing to the DSN.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply