Setting up a linked server to dBase 5 database in SQL Server 2000
Posted on 2003-03-14
I've hit a wall trying to establish a linked server to a dBase database from within SQL Server 2000. I have tried all kinds of combinations in the connection properties. I've tried OLE DB and using a system DSN (which works if I try to bring the data into Excel!)
SQL Server lets me create the linked server and I'll see it in the list, but if I try to see any of the tables I get the following error.
OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:
Error: 7399, Severity: 16, State: 1
Doing a Google search, I see lots of folks trying to do the same thing, being unsucessful, asking help and getting no responses. It has to be possible. I can connnect using the System DSN and Excel as well as in DTS with the standard dBase 5 connection.
I'm really under the gun on this one and will bump up the points if someone can get me an answer that works quickly.