How to Solve Sage 50 Error 40960
No prizes for guessing why Sage 50 is a highly regarded accounting software among st the accounting professionals and businesses alike. With its wide spectrum of embedded functionalities, Sage 50 has indeed allowed businesses manage their accounting and bookkeeping tasks more efficiently than ever before. However, one thing that is attached with most of the software is that they are not completely free of errors and the same applies to Sage 50 as well.Some of our regular readers have informed that they are struggling to get rid of the Sage 50 error 40960 and are looking for easy solutions to fix this issue. Are you one of them?
If so, we can be of some help. All you need to do is to go through this blog till the end. Here, we will provide a step-by-step and easy procedure to resolve this issue. We will also tell you the possible reasons why people get this error message . This will help you avoid such issues in future.
First things first! let’s get to know why this error occurs..
Causes of the Sage 50 Error 40960
The Sage 50 Error 40960 is also commonly termed as the Sage Database Connection Error. When this error occurs on your system, you will usually get the error message like Error: “Cannot access database (error=40960). Among many inherent issues that may contribute to this error, one of them is pretty common. Users mostly experience it when the Data Source Name (DSN) used by them while setting a database, points out to an invalid or incorrect server address.
Steps to Fix Sage 50 Error Code 40960
The best way to fix this issue is to reconfigure your DNS correctly. It will ensure that the DNS will point to the proper database server address. You should follow the steps given below-
- Open Data Sources (ODBC)
Please note– make sure to use 32 bit Data Sources (ODBC) on a 64 Bit Windows operating system
- Choose the correct DSN
- Click the Configure tab as shown below
- Now, with correct settings, complete the configuration process of the DSN.
- Restart the Sage software and check if you are still getting the issue.
We hope that with the sequential steps above, you would be able to resolve the Sage 50 error 40960 on your system. If you are still struggling with this issue, or if you are finding it difficult to carry out these steps, we would recommend you to speak to some of the authorized Sage experts.
📢Frequently Asked Questions
How to Resolve the Sage 50 40960 Error Caused by a Connection Issue with the Database?
Please note that the security software and firewall installed on your system are the primary sources of most of the connection issues. These software often block certain connections through some ports. The easiest way to troubleshoot such issues is to disable all the security software installed in the system and then try connecting to the database again.
What is the Procedure to Recreate the ODBC Connection to Pervasive Database?
Here are the sequential steps to do so-
🔷 Go to Windows Start menu
🔷 Click Start and then to All Programs
🔷 Navigate to Administrative Tools
🔷 Click on ODBC Data Sources (ODBC).
🔷 Now select the tab named System DSN .
🔷 Locate and click on the particular ODBC connection for Sage 300 ERP databases
🔷 Click on Configure
🔷 Note the settings you require to recreate this ODBC connection.
🔷 Click on Remove to delete this ODBC connection.
🔷 Now click on Add to recreate the ODBC connection.
🔷 Save changes.
🔷 Go to the Windows’ Start menu, select Start, All Programs, Administrative Tools,ODBC Data Sources (ODBC).
🔷 Select the System DSN tab.
🔷 Identify and select the ODBC connection for the Sage 300 ERP databases
🔷 Click Configure and make note of all the settings you need to recreate this ODBC connection.
🔷 Click Remove to delete the ODBC connection.
🔷 Click Add and recreate the ODBC connection.
🔷 Save changes.
I am Asked to Bypass the Windows Firewall ,to Fix the Sage 50 Error 40960. How to do this?
Here are the steps to follow-
🔷 First go to the Windows settings
🔷 Disable the Windows firewall
🔷 Start the Sage software to check if the issue still persists
🔷 If so, navigate to the Advanced Settings of the Windows firewall
🔷 Click Inbound Rules
🔷 Now create a new rule for the particular port used by Sage to connect to the database
🔷 Carry out the same steps for Inbound Rules as well
🔷 Note the name and description for these new rules you have just created, for future reference.
Reason Behind Sage 50: An Unknown Error Has Occurred Reconfigured Webmail Account that allows us...
When we try to open Sage 50 2019 accounting software to manage accounting tasks it sometimes interr...
Sage 50 is an all time best software to manage and book keep the company’s accounts and finances. ...
Sometimes, while working you need to change the computer. It can be due to any reason such as your ...
Report Your Issue
(Didn't find what you were looking for! Report your issue and get customized help from our Sage experts.)