Macola 7.5.x upgrade to Macola 7.6.300

[sweaverUK]

Hi

We are planning to upgrade Macola 7.5.103f to 7.6.300. Does anyone know if our custom crystal reports designed on the 7.5 Btrieve (6.15) will need re-writing. We will be installing Pervasive 9.x

Regards

SW

 

[abaldwin]

I think you will be ok if I recall properly. Would probably get a copy of some of your critical reports off to the VAR that is assisting with the change over and have them see if you are going to have problems. If they are using and ODBC connection you should be better off. Switching to an ODBC connection will only aid in eventually switching to sql.

Which begs the question.....Why not switch to SQL server?


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[crystalreporting]

The underying table structure wont have changed between 7.5.103 and 7.6.300 (other than the addition of some new fields and new tables). If your reports are currently using ODBC, then they should work fine - a 'verify database' within each report should be all they need.

It's been a while since I dealt with a Pervasive upgrade, but I seem to remember that one of them wouldn't let you easily delete or change the old DSN's once the upgrade was done i.e. it was much easier to delete the DSN's prior to the upgrade, then recreate them with the same name once the upgrade was done.

As Andy says, if you're not using ODBC now, you should start to convert your reports to ODBC as this will greatly simplify the conversion process if/when you upgrade to SQL.

Peter Shirley

http://www.srhconsulting.com

 

[MacolaHelp]

The tables did change in 103d, but, as Peter said, it was primarily to add tables and files. 76300 added more tables and changed some files, but, as of 76300b, they still haven't provided updated ddfs. Again, the changes were for additional data fields added from the filler or new tables added, so your existing reports should be fine if you used odbc. In addition to Peter's point about deleting the DSNs prior to the upgrade, one of the experts on the pervasive forum suggests uninstalling pervasive on the server before installing a new version. This makes sense to me in light of the fact that when you create a new database on the server, the odbc.ini files and dbnames.cfg are updated. If you remove the previous installation, then you can create the new datasources on the new database manager with the same name as the old one. If you used the ddf link in 6.15 to the macola files, you have to convert the reports to odbc in addition to creating the new DSN and pointing it to the correct tables. I have sometimes found that reports using ddfs were linked to the non _sql tables. In some cases, it is easier to redo the report with the new odbc and new driver rather than dink around with converting the old report and linking to the new DSN.