Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP(ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting. New visitors, please click here!
Hi, i know this is a common error in Accpac related to database access. we upgraded our servers windows from 2000 to 2003 and after the upgrade accpac was unable to run from client machines thus generating the error 'cannot access database (error 49153)'. interesting enough it runs perfectly from the server without any problem. Could it be I am experiencing the problem coz i installed Accpac and pervasive using the remote desktop? and how can i fix the problem?
Hi Jay, There is no firewall on the way, I have checked issues to do with access rights on the data folder in the server and everything is OK. Pervasive client was not showing the name of the server and I had to create it hence detecting the respective databases automatically but still getting the same error. I am now running out of options
Hi Jay, when I install Pervasive client transactional engine tests go through without any problem but the next step of testing relational engine i.e. Machine Name and Engine DSN (demodata) is not going through. could this be the reason why this whole thing is not working? and why should the test fail when I am pointing to the right Machine name?
1. You're not trying this through a Remote Desktop Connection (RDC), are you? You need to run Regedit and change HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities interface\Settings\Restricted Access On WTS client to 0.
2. You might have restrictive network policies that prevent local users from seeing the System DSN's of ODBC.
3. These aren't 64-bit OS's are they? You have to run a different version of ODBCAD32 in that case.
Jay Converse Sage 300 Whisperer
Thanks Jay, the genesis installation of ACCPAC and Pervasive on the server was after the upgrade to 2003 server, which i did without knowing its effect through RDC. When I tried creating a Database through the control center I was being prompted for a password and after a search and a long struggle on the Net came the idea of editing the Restricted Access to 0 on WTS, which I did and I was able to create the DB and log on to Accpac but on the server. When I tried the client I could not go through. we don't have any restricted network policies coz we are not running accpac for the first time. We are running a 2003 server is it a 64 bit OS i dont know