Is it possible to use the MS SQLServer linked server function to a Pervasive database with an "owner" set?
Everytime I attempt to use openquery, I get a message that says "error 51 - invalid owner".
I know I can use the "set owner" command and then I can get the queries to work, but this also doesn't work using openquery. The error I get there is something like "MSADSQL detects that this query returns nothing". The command I use there is:
select * from openquery (MYLINKEDSERVER, 'set owner = ''banana''; select * from linked_table')