I'm wanting to link tables from various DBs to one combined DB without using the PCC. I tried using an SQL statement via an ADO connection through an ODBC DSN, but this caused an error which said "you are not authorised to perform this operation". The SQL syntax was:
UPDATE X$File SET Xf$Loc = 'crm01\DCRM01CU.dat' WHERE Xf$ID = '1'
Also Access gives a similar error message when I try to update a linked File.ddf.
Updates work on the Billing table (using adoCon.Execute)in Demodata but that's not a system table.
How do I gain the correct permissions to perform such an update using SQL, or is it a restriction imposed by Pervasive's ODBC driver?
UPDATE X$File SET Xf$Loc = 'crm01\DCRM01CU.dat' WHERE Xf$ID = '1'
Also Access gives a similar error message when I try to update a linked File.ddf.
Updates work on the Billing table (using adoCon.Execute)in Demodata but that's not a system table.
How do I gain the correct permissions to perform such an update using SQL, or is it a restriction imposed by Pervasive's ODBC driver?