?
Solved

Peachtree Pervasive Workgroup/ Pervasive Client/Server get error 170

Posted on 2011-09-21
2
Medium Priority
?
1,830 Views
Last Modified: 2012-05-12
Customer has latest Peachtree Quantum. To simulate I downloaded and installed on a Domain server and 1 workstation. I used the .bat file supplied for the workstation.

Peachtree runs fine.

My app did use wbtrv32.dll for the client but it did not work. Switched to w3btrv7.dll and it did work as long as the other server where my app was running had Perv 11 32 workgroup.

Tried both 32 bit and 64 bit Perv 11 Trial Server on the server holding my app and not the Peachtree app from the single workstation and got error 170. Login needed.

Is it possible to have Pervasive Server on a different server where Peachtree is not installed and be able to launch both Peachtree account AND my app on the same workstation as long as user limits would not be exceeded.

Bob
0
Comment
Question by:bob_mechler
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 2000 total points
ID: 36576200
The status 170 is probably coming from the Client Cache Engine, or CCE.  When PeachTree installs, it installs the Workgroup Engine as a service.  BY default, this service is granted "Logon As" account as "Local System".  This Local system account has full access to the database engine locally, as well as on other Workgroup Engines (which do not enforce OS security).

When you use a Server Engine, which DOES enforce OS security, this lcoal system account doesn't have enough access.  To fix this, go into Services and find your PSQL Workgroup Engine in the list.  Right-click/Properties and go to the LogOn As tab.  Change the account being used to a domain account -- one which DOES have rights to the server-side data.  Once this is done, you'll be home free.
0
 

Author Closing Comment

by:bob_mechler
ID: 36576954
Well explained. Complete. Should have thought of this myself. Makes total sense since the same app works fine directly on the server after logging in with a domain login.
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
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

764 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