• 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