Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Trying to updating a ddf file with SQL

Trying to updating a ddf file with SQL

Trying to updating a ddf file with SQL

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?

RE: Trying to updating a ddf file with SQL

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.

RE: Trying to updating a ddf file with SQL

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close