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