I´m NEW IN PERVASIVE, HOW OPEN DATABASE

[JMRR]

I'm HAVE ONE DATABASE WHICH FRIEND MIGRATE TO PERVASIVE.SQL 2000, NOW NEED OPEN THE DATABASE. WITH THE CONTROL CENTER CREATE THE ODBC CONNECTION BUT WITH SQL MANAGER REPORT ERROR, SQLSTATE=S1000, NATIVE error code=0 UNABLE TO OPEN TABLE , NO SUCH TABLE OR OBJECT.

I'm NOT KNOW WHAT MAKE BAD. I'm FOLLOW THE STEPS IN THE USER GUIDE AND CANT OPEN THE DATA BASE.

HELP ME

 

[Guest_imported]

JMRR: I work for Pervasive in the engineering department. I'll help you with this problem. Follow these steps and see if you area able to find your table in the database which you are attached to.
Control Center tree; expand Engines; expand the engine (server name) where the database resides; you should see at least Demodata in this list as that is created during install of PSQL; find the database where the table that you are trying to open resides and expand that database; double click on "Tables"; the list of all the tables in that database will show up on the right side of PCC. You can then double click on the table you want to view. If you can get to the table following these steps, then there must be something wrong with the statement syntax or format of the table name. Its also possible that your DDF is messed up -- could it have a relative path in it -- such as a mapped drive that is no longer available? It is highly recommended that you use full UNC paths in your file names so that your DDFs are portable, and accessible even when network mappings change. You can view the information in your X$FILE DDF file to see what the X$LOC value is for this table. If the value for the location is not correct, you can change it by right clicking on the table from the list in PCC; select edit table design; chose the statistics tab.
Let me know if this does not solve your problem.
Debie