Trying to updating a ddf file with SQL

[timeframe]

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?

 

[Vancouverite]

Your best bet is to update to SP3 of Pervasive.SQL. This includes a number of additional SQL ALTER commands that allow you to point to different files, change the DDF definition without changing the physical file, etcetera.

 

[timeframe]

Yes I've got ALTER table to work now with SP3 installed. You can't use UPDATE on a system table it seems.