Re: linked server problems

From: Matt Tapia (mtapia_at_inbizservices.com)
Date: 06/01/04

  • Next message: Rick Rohne: "Re: Purge old ROWS" 
    Date: Tue, 1 Jun 2004 15:31:10 -0500

    I figured it out:

    SELECT * FROM linked_server.database.dbo.table_name tn

    "Matt Tapia" <mtapia@inbizservices.com> wrote in message
    news:ebXRQoASEHA.1312@TK2MSFTNGP12.phx.gbl...
    > I do the following to link a server:
    >
    > EXEC sp_addlinkedserver 'MainLinkedServer', 'SQLServer OLEDB Provider',
    > 'SQLOLEDB', 'MATT', NULL, NULL, 'WEEK'
    >
    > It says it links fine (no errors), but when I do a select on a table I
    know
    > exists
    >
    > select distinct T1."Institution" c1 from 'MainLinkedServer'...myTable T1
    >
    > I get the following error:
    >
    > OLE DB provider 'MainLinkedServer'does not contain table 'myTable'. The
    > table either does not exist or the current user does not have permissions
    on
    > that table.
    >
    > OLE DB error trace [Non-interface error: OLE DB provider does not contain
    > the table: ProviderName='MainLinkedServer', TableName='myTable'].
    >
    > any ideas?
    >
    >
    >
    >
    >

  • Next message: Rick Rohne: "Re: Purge old ROWS"