Hi All,

We are using Pervasive SQL 2000 for our ERP package, currently we are
doing fresh developments in this package. We are facing a pecular
problem in which we are not able to open any tables in Control Center,
but the data is accessible in VB. Due to this we are not able to make
any changes to the table design.

Whenever we click on the tables in Control Centre I get the following
message "[Pervasive][ODBC Client Interface][LNA][iODBC][Driver
Manager]No such file or directory". I am also not able to get a list of
the tables also.

Please assist me.

Thanking you all in advance.

Regards,
Samson

Start with your X$File table. Try to open this & see if it looks OK or
not. Then, right-click the database in the PCC, select Tasks, and then
Check Database. Have it check through the files for any problems. If
the core DDF's themselves have problems (these are the X$... files)
then the rest will also have problems.

If X$File seems OK and passes the consistency check, the next step is
to look at the fields for xf$Loc in this table to see if they are
correct. If you have paths in here that don't match your current
location, then you can also get the error you are reporting.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 10/2006 ***

Samson wrote:

Hi Bill Back,

I tried running the Check Database utilitity, but once I select the
database and then on clicking on next itself I get the error
"[Pervasive][ODBC Client Interface][LNA][iODBC][Driver
Manager]No such file or directory",

What do i do now? How do I check the X$File table?

Regards,
Samson


Bill Bach wrote:

Hi Samson,

In that case, I suggest going on to Bill's second step. What the error
is telling you is that, in fact, the files are not where you or the
entries in X$File are expecting them to be.

Wayne Freeman
Analytica Business Systems
www.analyticabiz.com

Samson ha scritto:

You may also need to check, the database directory, defined in the
Named Database. If the directory is wrong (and does not point to the
DDF's), then the database will also be unreachable.

To get to the database names, right-click on the Configuration item in
the PCC and select "Maintain Named Database". Then, find the entry
that relates to your database and verify the paths therein.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 10/2006 ***


Samson wrote: