Solved

Peachtree Pervasive Workgroup/ Pervasive Client/Server get error 170

Posted on 2011-09-21
2
1,797 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 500 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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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…
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…

691 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