Solved

ACCPAC error 49153

Posted on 2010-08-18
1
4,744 Views
Last Modified: 2013-11-15
Hello everyone.

We had a server failure on our ACCPAC server and had to recover to a new machine.

The new server has Pervasive 8.6 with ACCPAC version 5.3A installed on it and we restored our ACCPAC folders.

Pervasive sees the data tables and ODBC sees and tests the data files just fine.

We edited the registry path to point to the new server and reconfigured the ODBC and pervasive databases on the workstations.

At that point ACCPAC would come up and ask for the login.  They click OK and we get the big old.

"Cannot access database (error=49153).  See Help for more information"

Well frankly help is useless on this error.

We have restarted the server and workstation to make sure pervasive got off on a good foot.  And I have ensured that the users have full control through both the file share and file permissions to the ACCPAC folders and files.

I am not sure where to look now.

Anyone have any ideas.
0
Comment
Question by:PCCUtech
1 Comment
 

Accepted Solution

by:
PCCUtech earned 0 total points
ID: 33475714
Turns out that the problem was an easy fix.

Essentially the issue was that you not only need to configure the odbc and the pervasice db connection but you need to go into ACCPAC and run the database setup and configure the data sources there.

ACCPAC support said that in the newer versions this is not an issue as it just uses the odbc connection.

Thankfully the problem has been solved!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Norton antivirus 11 73
Backup Data/Portable NAS storage 4 65
Win 7 OS unable to install Win updates 3 138
Software for IT quotations, invoices, delivery orders 2 37
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

912 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

21 Experts available now in Live!

Get 1:1 Help Now