Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002

    Cool Unanswered: Linked Server to DBASE 5 Tables

    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.


  2. #2
    Join Date
    Aug 2002
    Can't you use DTS to get the data from DBase5.
    --Satya SKJ
    Microsoft SQL Server MVP

  3. #3
    Join Date
    Sep 2002

    Using DTS for DBASE 5 Access

    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 .....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts