{"id":93677,"date":"2024-01-15T07:27:20","date_gmt":"2024-01-15T07:27:20","guid":{"rendered":"https:\/\/www.askforaccounting.com\/?p=93677"},"modified":"2024-01-15T07:27:20","modified_gmt":"2024-01-15T07:27:20","slug":"sage-error-40960","status":"publish","type":"post","link":"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/","title":{"rendered":"Sage 300 Error 40960"},"content":{"rendered":"\n<p>Today, in this blog we will discuss the root causes of the Sage 300 error 40960 as well as solutions to resolving it. Sage is a well-known solution for managing business-related activities, with a plethora of features and functionalities. However, while using <a href=\"https:\/\/askforaccounting.com\/sage\/sage-error-code-message-issues\/\">Sage users may encounter various error codes<\/a>.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#What_is_Exactly_Error_Code_40960\" >What is Exactly Error Code 40960<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Sage_300_Error_40960_Causes\" >Sage 300 Error 40960 Causes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#How_to_Fix_Sage_300_Error_40960\" >How to Fix Sage 300 Error 40960<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Solution_1_Double-check_your_DSN_Settings\" >Solution 1: Double-check your DSN Settings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Solution_2_Resolve_the_Connection_Issue\" >Solution 2: Resolve the Connection Issue<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Other_Sage_300_Errors_Issues\" >Other Sage 300 Errors &amp; Issues<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#FAQs\" >FAQ&#8217;s<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#What_Exactly_is_Sage_300\" >What Exactly is Sage 300?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Is_Sage_300_Hosted_in_the_Cloud\" >Is Sage 300 Hosted in the Cloud?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#Is_Sage_300_ERP_Software\" >Is Sage 300 ERP Software?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/#How_do_you_Create_an_Invoice_in_Sage_300\" >How do you Create an Invoice in Sage 300?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"what-is-error-40960-in-sage-300-program\"><span class=\"ez-toc-section\" id=\"What_is_Exactly_Error_Code_40960\"><\/span>What is Exactly Error Code 40960<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This Sage 300 error 40960 was reported by many users even after the configuration of the database settings. When you fail<strong> to connect with the database<\/strong>, a database error is usually found. To get rid of the 40960 Sage error, you must first configure the database. You may also have the same problem because you are using an incorrect server with a data source name (DSN).<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-black-color\"><strong>Error 40960<\/strong><\/mark>&#8211; &#8220;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-black-color\">Can&#8217;t access database.<\/mark>&#8220;<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sage-300-error-40960-causes\"><span class=\"ez-toc-section\" id=\"Sage_300_Error_40960_Causes\"><\/span>Sage 300 Error 40960 Causes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An error has occurred as a result of an incorrect server when a Data Source Name (DSN) used in database setup points to the incorrect server.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-fix-sage-error-code-40960\"><span class=\"ez-toc-section\" id=\"How_to_Fix_Sage_300_Error_40960\"><\/span>How to Fix Sage 300 Error 40960<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Assume you&#8217;ve already installed all of the most recent Sage 300 releases. This could be the cause of Sage 300 error 40960. Also, ensure that you are logged in as an administrator to the Sage 300.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/www.askforaccounting.com\/wp-content\/uploads\/2022\/02\/ODBC-Database-min.png\" alt=\"sage 300 odbc data source administrator\" class=\"wp-image-97631\" style=\"width:480px;height:auto\"\/><\/figure>\n\n\n\n<p><strong>Now, proceed to implement the solutions listed below.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"solution-1-double-check-your-dsn-settings\"><span class=\"ez-toc-section\" id=\"Solution_1_Double-check_your_DSN_Settings\"><\/span>Solution 1: Double-check your DSN Settings<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To begin,&nbsp;open&nbsp;the 32-bit DSN settings.<\/li>\n\n\n\n<li>Then, using Sage 300,&nbsp;select&nbsp;the DSN.<\/li>\n\n\n\n<li>After that,&nbsp;click&nbsp;Configure and make any necessary changes to the DSN settings.<\/li>\n\n\n\n<li>Finally, select&nbsp;Save.<\/li>\n<\/ul>\n\n\n\n<p><strong>Methods to DSN Configuration<\/strong><\/p>\n\n\n\n<p>DSN (Database Source Name) settings must be changed.<\/p>\n\n\n\n<p><strong>To do so, follow the instructions below:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate&nbsp;to the 32-bit DSN (Data Sources) settings.<\/li>\n\n\n\n<li>Select&nbsp;the DSN used by Sage 300.<\/li>\n\n\n\n<li>Click&nbsp;Configure.<\/li>\n\n\n\n<li>Make sure that all of the&nbsp;DSN settings&nbsp;are correct.<\/li>\n\n\n\n<li>Save&nbsp;the file.<\/li>\n\n\n\n<li>Restart&nbsp;the system and begin using the software again.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"solution-2-resolve-the-connection-issue\"><span class=\"ez-toc-section\" id=\"Solution_2_Resolve_the_Connection_Issue\"><\/span>Solution 2: Resolve the Connection Issue<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can see that a connection problem with the database usually leads to an error of Sage 40960. Different security software can block certain links via specific ports. In such a case, disabling security software is the best way to address the issue. You will then be able to connect to the database.<\/p>\n\n\n\n<p><strong>See now the next steps to remove connection errors<\/strong>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Disable the firewall first and&nbsp;verify&nbsp;that the Sage 40960 error is&nbsp;corrected.<\/li>\n\n\n\n<li>If the problem is fixed,&nbsp;select&nbsp;Advanced Windows Firewall Settings.<\/li>\n\n\n\n<li>Then&nbsp;select&nbsp;Inbound Rules and create a new port rule that connects Sage to the database.<\/li>\n\n\n\n<li>Execute&nbsp;the same&nbsp;Outbound&nbsp;Rules.<\/li>\n\n\n\n<li>Save&nbsp;the name and description, finally.<\/li>\n<\/ul>\n\n\n\n<p>To resolve Sage 300 error 40960, it is highly recommended to update Sage 300 before heading for any of the aforementioned solutions. If you are still struggling with the same issue and failed to resolve it, you may contact our <a href=\"https:\/\/askforaccounting.com\/sage\/sage-chat-support\/\">Sage chat helpdesk<\/a> experts&#8217; staff of specialists whenever you have a problem call or you can also online chat with <a href=\"https:\/\/askforaccounting.com\/sage\/sage-tech-support\/\">Sage experts<\/a>.<\/p>\n\n\n\n\n\n<h4 class=\"wp-block-heading\" id=\"other-sage-300-errors-issues\"><span class=\"ez-toc-section\" id=\"Other_Sage_300_Errors_Issues\"><\/span>Other Sage 300 Errors &amp; Issues<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Sage 300 encompasses the entire business landscape and allows you to micromanage and micro-analyze everything related to your business. This is an excellent piece of software for planning your entire fiscal year. Furthermore, once you&#8217;ve gathered enough data, you can always use reporting tools to analyze it and gain valuable insights. Sage 300 is available in a variety of plans, making it highly customizable. You can select the plans and versions based on your company&#8217;s needs.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><a href=\"https:\/\/askforaccounting.com\/sage\/sage-300-cre-support\/\">Sage 300 CRE Consultant<\/a> &#8211; Sage 300 is known as a construction and property management (CRE) program.<\/td><\/tr><tr><td><a href=\"https:\/\/askforaccounting.com\/sage\/sage-error-49153\/\">Sage 300 Error 49153<\/a> &#8211; When Sage 300 users try to log in to the Sage 300 ERP application or access any company or data file.<\/td><\/tr><tr><td><a href=\"https:\/\/askforaccounting.com\/sage\/crystal-reports-failed-to-retrieve-data-from-the-database-sage-50\/\">Sage 300 Failed to Retrieve Data from the Database<\/a> &#8211; When Sage 300 users tried to print existing crystal reports after installing Sage fixed assets.<\/td><\/tr><tr><td>Sage 300 Error Batch- When users record any entries that could not be posted.<\/td><\/tr><tr><td><a href=\"https:\/\/support.na.sage.com\/selfservice\/viewContent.do?externalId=18397&amp;sliceId=1\" target=\"_blank\" rel=\"noopener\">Sage 300 UI Container has Stopped Working<\/a> &#8211; When users try to print reports to preview on a Windows 2008 R2 or Windows 2012 server.<\/td><\/tr><tr><td>Sage 300 Error 2147747072 &#8211; When users run a macro from the Sage 300 desktop.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"faq-s\"><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQ&#8217;<sub>s<\/sub><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1631682290393\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"What_Exactly_is_Sage_300\"><\/span>What Exactly is Sage 300?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Sage 300 is the Enterprise Resource Planning software that the Sage group provides. You will be able to manage manufacturing, distribution, inventory, sales, accounting, and payments with the help of Sage 300. It also enables you to analyze every aspect of your business. Sage 300 is Sage&#8217;s flagship ERP (Enterprise Resource Planning) software. With it, you can manage Accounting || Manufacturing || Distribution || Inventory || Payments and Sales.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1631682325185\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"Is_Sage_300_Hosted_in_the_Cloud\"><\/span>Is Sage 300 Hosted in the Cloud?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Yes, Sage 300 is cloud-based accounting software that is an excellent choice for expanding your service or distribution businesses. This software includes cloud-based features that assist small and medium-sized businesses in meeting their objectives. You can also access Sage 300 from any location and at any time.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1631682348348\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"Is_Sage_300_ERP_Software\"><\/span>Is Sage 300 ERP Software?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Yes, enterprise resource planning (ERP) software is used to manage daily business activities such as project management, accounting, compliance and risk management, and supply chain operations.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1631682384858\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"How_do_you_Create_an_Invoice_in_Sage_300\"><\/span>How do you Create an Invoice in Sage 300?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>To enter an invoice into Sage 300, follow the steps below&#8230;<\/p>\n<p>\u25cf To begin, open Accounts Payable and then select A\/P Transactions.<br \/>\u25cf Now, select Invoice Entry and, using the Batch Number field, select an existing batch.<br \/>\u25cf Alternatively, you can start a new batch.<br \/>\u25cf After that, choose Create New Entry and enter a description for the entry.<br \/>\u25cf Finally, in the Document tab, enter the header information.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Today, in this blog we will discuss the root causes of the Sage 300 error 40960 as well as solutions to resolving it. Sage is a well-known solution for managing business-related activities, with a plethora of features and functionalities. However, while using Sage users may encounter various error codes. What is Exactly Error Code 40960 &#8230; <a title=\"Sage 300 Error 40960\" class=\"read-more\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-error-40960\/\" aria-label=\"Read more about Sage 300 Error 40960\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":111155,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-93677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-accounting"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"Lawrence Flanagan","author_link":"https:\/\/www.askforaccounting.com\/sage\/author\/openfolderbin\/"},"_links":{"self":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/93677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/comments?post=93677"}],"version-history":[{"count":0,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/93677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/media?parent=93677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/categories?post=93677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/tags?post=93677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}