I have an odbc connection setup for my pervasive.sql database and it tests ok., When I open the Pervasive Control Center I can view a list of all the tables but if I try to open one of them I get the following error:

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

In addition, if I try to open an asp page that accesses the db it gives the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: PM Occupant Info.
/SysAdmin/adminC.asp, line 13


The db works fine on another server. So it has to have something to do with the configuration. Any ideas?

It might be a configuration issue if the database has paths in the DDFs. Issue a "select * From x$file" and look at the xf$loc for the table(s) in question. If there is only a filename, make sure the file with that name is in the same directory as the DDFs. If it's got a path with the name, make sure the file exists in the path.

I checked and there are not any paths. I use the same ddfs for the other db that works, so I doubt that is the issue. I think it must have something to do with how I have the ODBC setup.

Any other ideas on what would cause this error?

It might have to do with the way the DBname is set up but the ODBC driver just points to the DBName.

What happens if you copy the DDFs/Data file to another location on this box, create a new DBName/DSN pointing to the copy? Does it give the same error?

Yes I get the same error with that test.

Thanks for your help.

Any other ideas are welcome. I don't know what else to try.

Any other ideas?