Unanswered: Database does not appear in control centre and links to RDB?
I have a customer who is using pervasive sql.8 as a backbone to a system called AutoEDMS. I am not familiar with pervasive at all ( I am coming from SQL and Oracle background). I need to export some data to ascii or open the db in another db (access, sql, oracle, etc).
I logged in to the control center on the server and I see a local engine with only the demodata registered. I cannot see the actual database autoedms is using. Unfortunately the system administrator (IT) left the company and no one has a clue how to administrate the database.
Customer mentioned something about rdb file as the database files. I could not find any documentation about RDB and pervasive sql on the web.
Any idea why is the db not registered and what is the connection between the pervasive sql db and rdb files?
How can I open the rdb file or load it in the control centre?
Looking at the hex dump it looks all ascii, but I am not sure.
PSQL databases are not automatically added in the PCC. You would need to add it manually. Most applications do not need or use databases because they access the data files directly through the Btrieve API.
If you have DDF files for the database files, you can add a database to the PCC using those DDFs and data files.
Once you have a database in PCC, you can use any of your favorite tools to export the data.
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.