Post reply

Help with linked server

  • July 22, 2005 at 1:22 pm

    #576552

    When you create a linked server with the Jet 4.0 OLE DB Provider you need to add the provider string.

    Provider String: MS Access;Pwd=mypassword

    Then you can use the OpenQuery function to execute the query

  • November 11, 2009 at 11:50 pm

    #1078177

    SELECT * FROM mylinkedserver.yourcatalogname.mytable

    EG:

    select * from linkedservername.catalogname.tablename

    Trend: Linked Server Name

    CatalogName: BestData

    Tablename:simons

    select * from Trend.BestData.simons

    Thanks,

    Satish Kumar.

Viewing 2 posts - 16 through 16 (of 16 total)

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