All, I am trying to link my SQL 2008 64bit server to a legacy dBase III program that we have on site using the linked servers in SQL. After much reading on the internet and trial and error I have downloaded the ACE 64bit driver and I am using the following query:
EXEC sp_addlinkedserver @server = N'WINTAM',
@provstr=N'DBASE IV' ;
This completes however when I go to test the connection I get an error that says the @datasrc is not a valid path. I know the path is correct so it must be something different.
Currently I am using a SSIS job to upload information from this database hourly but I want to be able to update it in real-time so any other suggestions on how to do this are also welcome.