Post reply

Pls Help: Linked Server To dBASE Files

  • August 4, 2003 at 8:52 am

    #80776

    Greetings,

    I have a directory on the network called 0:\ESPEC\PDM, which contains dBASE files (*.dbf).

    I have created a linked server in SQL Server using the following command:

    exec sp_addlinkedserver

    @server='Test2',

    @srvproduct='db5',

    @provider='MSDASQL',

    @datasrc='PDMdBASE'

    I also have an ODBC data source called PDMdBASE (system DSN) which points to the directory containing the dBASE files. When I try to access data in the dBASE files SQL Server tells me that my table name does not exist, even though it does:

    SELECT * FROM Test2.[O:\ESPEC\PDM]..ATAB

    Produces:

    OLE DB provider 'Test2' does not contain table '`O:\ESPEC\PDM`\`ATAB`'. The table either does not exist or the current user does not have permissions on that table.

    ATAB.DBF DOES exist in O:\ESPEC\PDM

    Does anyone have any clues on how to make this work?

    Thanks for your help.

  • August 7, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 7, 2003 at 11:12 pm

    #469118

    Have you tried simply the Linked Server name plus the table name? IE:

    SELECT * FROM Test2...ATAB

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

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

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