[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Btrieve_Macola

Posted on 2011-04-26
10
Medium Priority
?
633 Views
Last Modified: 2012-05-11
I have Macola running on a Win2k server that I wanted to retire. However, I still want to use Macola on another server(its not our active accounting software so we no longer have support)  I have installed Macola on a Win2003 server and WinXP PRO station after I have installed Pervasive 8.6 server on both of these machines. I am not having sucess in launching the client locally from either of these host machines. I get the message ,after launching the client , that says it is starting Progression(Macola) then I get this message "Client must be running Btrieve 6.15 or greater 8.60 found". The only difference on working WIN2K server and the problem ones is that Pervasive 8.5 is running instead of 8.6.
Is there something in a Cfg or ini file I need to change? I have looked there but cant find a solution.

Thanks
0
Comment
Question by:cebu1014
  • 6
  • 4
10 Comments
 
LVL 18

Accepted Solution

by:
mirtheil earned 1500 total points
ID: 35470101
I had gotten this once from Pervasive.  It might work:
Create a new Registry Key in the “MyEXE.exe” (where MyEXE.exe is the EXE used by Macola)  key in the Operating System Registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Settings Override\peachw.exe]
"Version Level"="6.15"
"Version Type"="9"
To do this, you can use Regedit (16-bit registry editor for Windows 9.x, Windows NT, Windows 2000 or Windows XP), or you can use Regedt32 (32-bit registry editor for Windows NT, Windows 2000 or Windows XP).

Create a new Key under HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\ called “Settings Override”.
Create a new Key under HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Settings Override called “MyEXE.exe”.

In the right pane (with the MyEXE.exe key highlighted), create 2 new String values:
“Version Level” which should have a Value of “6.15”
and
“Version Type” which should have a Value of “9”
Now, when you launch Macola, it should now detect Pervasive.SQL as Btrieve 6.15, which will allow it to load.

0
 

Author Comment

by:cebu1014
ID: 35470408
I havent got it to work yet. Here is what I have done. Created the keys under ....MicroKernel Router. The executable is Macola32.exe

Wanted to see if this is what you meant... See attached. Notice the 2nd image in file there is a version 8 key with settings information already there. Is this helpful?
macola32exe.doc
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 35470503
You might try a type of "N".  
The keys look okay. Are you getting the same error?  
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:cebu1014
ID: 35471280
Yes the same error. I wouldnt know how to chage the type to "N"

Dont think I could put these same key entries under version 8 settings of the microkernal router?? These can be tried. I have gotten an error will btrieve not found as well.
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 35471364
Sorry, I should have been clearer.  You should change the value of the "Version Type" from the value of "9" to the value "N".  
I don't think the keys belong under the "version 8" setting.  When I got the information from Pervasive, it wasn't under any version.  

Basically, this is hack to work around Macola making a bad assumption about the version of PSQL.  Typically when this occurs, the program makes a Btrieve version call and then is checking for a specific range rather than a more generic "minimum version or greater" check.  

Another option would be to uninstall PSQL v8.6 and install v8.5.
0
 

Author Comment

by:cebu1014
ID: 35472787
Thanks. I dont have version 8.5. I am not sure who installed v8.5on the working server. We have pervasive 2000. I wonder if that would work. I am fairly sure in the older days pervasive 2000 was used to run the macola software and later was upgraded to v8.5
0
 

Author Comment

by:cebu1014
ID: 35889928
Been gone for awhile.

Does your instructions change if the machine in question is a client or server?

Thanks
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 35889952
It should not make a difference.  
You need to create the keys where the application is running not specifically where the engine is running.  
0
 

Author Comment

by:cebu1014
ID: 35892066
Here is the situation,
I have the engine running version 8.6 and run macola loaded on my PC . I get the error.

However, when I run macola from the same PC as a client with Macola installed on the server(the one I want to retire) running version8.5. Macola works.

My guess is that macola is using the btrieve files on the same machine that has the executable to run macola.

With little documentation and no copy of version 8.5, I am assuming macola will work up to version 8.5 and not higher.
0
 

Author Closing Comment

by:cebu1014
ID: 35916136
I found an answer through extra trial and errors. However, I gave the user points for the additional information that pointed me to right direction,
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question