Hi,

everytime we want to open a table using Pervasive Control Center, we
get the following error:

ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: BKARCUST.
No such table or object

Also we noticed that the X$file, X$Field and X$Index are empty.

one way to fix this problem was copy these files from a backup.

But today not even that is fixing the problem.

We cannot connect any crystal o ms access reports to the sql server.

Strange and bizare.
The system tables x$file and friends are the SQL schema for the data
files. If they are empty then there is no SQL schema.

Since you have empty ones instead of populated ones or none at all it
would almost sound as though somehow the database is getting created
on top of itself. Normally that just picks up the existing ddf files
unless the old ones are removed first. Uninstalling the database
engine does not do that. Once you get the files restored from backup
and the engine picks them up you might want to flag them read-only to
keep them from disappearing again.

Leonard

On 14 Mar 2005 08:10:49 -0800, cholotron (AT) hotmail (DOT) com (Bre-x) wrote: