I am trying to create a linked server to some dbase 5 tables. I have read several other posts about using the OPENROWSET option and that does work however, I would like to be able to create a linked server for easier access.
End Goal: I am developing an ASP based app that needs to join a DB5 table to a SQL table.
Any help on the linked server properties in Enterprise Manager for dbase5 or on the proper sp_addlinkedserver function for dbase5 would be highly appreciated.
JoeCan't you use DTS to get the data from DBase5.|||I have pulled the tables in with a DTS package very easily however, I would like to be able to access the data real time in it's current place. for example:
Select sqltable.Name, dbasetable.BillCharges
From sqltable
Inner Join database...dbasetable On
sqltable.AcctNum = dbasetable.AcctNum
--------------------
By using an example in one of these forums I do have another work around:
SELECT sqltable.Name, dbasetable.BillCharges
FROM OPENROWSET('MSDASQL','DRIVER={Microsoft Dbase driver(*.dbf)}' ,'SELECT Name, AcctNum FROM \\Server\Data\dbasetable.dbf') dBase
Inner Join sqltable On
sqltable.AcctNum = dbase.AcctNum
But this is a little too slow for an asp application.
Thanks for the reply ....
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment