Hi,

I've got a database that I connect to using odbc and
want to check the connection using the control center
when I open a table or even the ddf files I get an error
odbc error:sqlstate = S1000,native error code = 0
unable to open table : ......
The Microkernel cannot find the speified file(Btriev Error 12)

Al the ddf files and btriev files are in the same dirrectory
A0001 and the btrieve file is A001_01
when I use the function executer I have to enter the user ea 03
and the I can connect to the btrieve file ok

But when I go to task \ edit table disign I cannot see the fields of
the file location

Can Enyone tell me what I'm forgetting or doing wrong

Kind Regards
Kevin

Open the X$FILE table and look at the XF$LOC field for the table in question. Does it show just the file name? If not, then the data file needs to be in a directory other than the directory where the data file is located.

THe problem is I can't open the ddf files they give the same error as the
tables has this something to do with user.ddf
in the dir of the database I have only got the
file.ddf field.ddf and the user.ddf but no index.ddf

in the control center i get all the tables and the
file.ddf index.ddf and the field.ddf

but I cannot open the tables nor the ddf files

Kevin

In that case, I would verify the path of the database name itself. You can right click on the "Configuration" node and select "Maintain Named Databases". Then you'll want to find the one you're using and verify that it's pointing to the right path for the DDFs and the data files.

We get the same error, resarting the services cures it for a short time before it happens again. I have checked our X$File when this happens - its empty? so are all the other system files. I tried deleting the database and re-creating this made no difference. Resarting the services is all we can do. Why would this happen every so often.

I've never seen that behavior. What's in the PVSW.LOG file?

The log shows no indication of problems. Do I need to set Pervasive to log specific errors?

No, it should log issues automatically. Is there anything in the Event Log?

I've had the same problem where X$File, X$Field and X$Index tables are all empty. I've verified the "Maintain Named Databases" as you suggested and checked the pvsw.log & event log and all seems ok. The only solution was to restart the services. Can you throw some light onto why this is happening, and what I can do to prevent it from happening again?