1. Home
  2. General Accounting
  3. BusinessVision and Pervasive (technical question)

BusinessVision and Pervasive (technical question)

Hello all, I have a fairly technical BusinessVision question.

I would like to view the data in BusinessVision's tables. I can create a database in Pervasive.SQL Control Centre just fine, but I can't get it to read any of BusinessVision's tables. I also tried creating the Pervasive database in the same folder as the BusinessVision tables, but it still did not read the tables. I can currently import the tables (as .btr files) one by one, but there are too many tables to do this manually, and I am not even certain if Pervasive creates a new table when it imports an existing table, or if it just reads the existing table. How can I get Pervasive to read BusinessVision's tables?

BV version is 7, Pervasive is 8.6.

Thanks in advance!

Reply to
lord.zoltar
Loading thread data ...

Not knowing BusinessVision specifically, are their databases open for viewing in this manner? Or have they locked them to protect the data integrity? I always get nervous when someone wants to view data outside of the application. It is one thing to use a report-writer of some sort to access the data, but another to use database software to do so. Just my humble opinion.

I would check with Bus> Hello all,

Reply to
TKnTexas

Not knowing BusinessVision specifically, are their databases open for viewing in this manner? Or have they locked them to protect the data integrity? I always get nervous when someone wants to view data outside of the application. It is one thing to use a report-writer of some sort to access the data, but another to use database software to do so. Just my humble opinion.

I would check with Bus> Hello all,

Reply to
TKnTexas

It turns out that there is a seperate installer to install the DDF's for Pervasive. This installer also puts the files in non-obvious places. This installer does not run as a part of the normal installation process, which is why I couldn't figure out how an old workstation had the setup I wanted, but I couldn't duplicate it. Yeah normally I'd agreee that it's a bad idea to access the tables manually, but this is for a development project with testing data, not production data. The tables get "reset" a couple times a day anyway.

Reply to
lord.zoltar

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.