Post reply

LinkedServers and Views

  • December 15, 2004 at 8:43 am

    #102311

    I have set up a linked server to a Pervasive Database from my local SLQ Server. Using OPENQUERY I can run queries against the Pervasive Database successfully(only tested SELECT so far). I would like to set up Views so I do not have to use OPENQUERY in my code(I am a programmer by trade and do alot of SQL SERVER admin stuff as well). Everytime I go to save the view it bombs out. My question is.. Is it possible to save views to linked servers using the OPENQUERY statement?

     

  • December 15, 2004 at 10:48 am

    #533995

    You would not use openquery in your view.  You would use the four part name as follows:

    select * from servername.databasename.owner.table

  • December 15, 2004 at 12:24 pm

    #534019

    I have tried that but have been getting this error.

    Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.

    OLE DB error trace [Non-interface error].

    I have been able to query the linked server from query analyzer using the OPENQUERY statement but have not using the four part name as you suggested.

    I guess the OLE DB provider just doesn't handle Pervasive stuff.

    Thanks

  • December 15, 2004 at 12:31 pm

    #534023

    Sorry, I missed the part where you said it was a Pervasive database.  I thought we were dealing with two SQL Servers. 

  • December 15, 2004 at 12:34 pm

    #534025

    That would make it too easy. lol

Viewing 5 posts - 1 through 4 (of 4 total)

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