Solved

Peachtree Pervasive Workgroup/ Pervasive Client/Server get error 170

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now