[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Peachtree Pervasive Workgroup/ Pervasive Client/Server get error 170

Posted on 2011-09-21
2
Medium Priority
?
1,893 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

656 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