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.
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.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.