SQL Link TO FreeTable DBF

  • Hi,

    SQL Sever 2000. i want to make Link Server for DBF file,

    Step Taken.

    1. Created a [System DSN] using -- Micorsoft Visual Foxpro Driver.

    2. Linked SQL Server USING MSDASQL.1 .

    It shows me all table but wen i try to access table using query it pop-up table not exists error .

    Query i use to access table

    Select * from Linkservername...TableName

    Kindly guide me in this regard, or any other option available to resolve This.


    Kindest Regards,

    Mohd Haneef

    Haneef@AFG.COM.KW

  • This was removed by the editor as SPAM

  • HI,

    Since no one reply, i changed my approach rather,

    i expect sure some guidence in working around with DTS, there are many detail available related to DTS(SSIS), accordingly i glance thru all of them and have few question, i will be forwarding today later,

    Requesting your Kind attention dude,

    Regards,,,

    Mohd Haneef.


    Kindest Regards,

    Mohd Haneef

    Haneef@AFG.COM.KW

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

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