I have 2 Pervasive client connections on my PC (data on 2 different servers) and want to run a query to insert records from a table in one database to a table in the other database. i.e. INSERT INTO Server1.Table1 SELECT * FROM Server2.Table1 Whenever I try and run this, I get the following: ODBC Error: SQLSTATE = S1000, Native error code = 0 Unable to open table: Table1. Cannot locate the named database you specified(Btrieve Error 2301) Is this not possible in PCC ? I'm running 8.7 Thanks!

When you specify "server1" or "server2", the PSQL engine is looking for a database name not a server name. 

It's not possible to select from one server and insert into another server through ODBC through the PCC.  

 

If you need to insert all the records from table1 (no WHERE restriction) you can do it from DOS prompt:

butil -copy btrv://server2/databasename?table=table1  btrv://server1/databasename?table=table1

 

Rokson