How to resolve ERROR [S0000] encountered while accessing SData over the Web for Sage 100 ERP

Many a times due to various unpredictable reason we encounter numerous errors while browsing over the web some are known and some are not, since not everyone has wisdom about the errors that are encountered on the screen. So in this blog we are focusing on understanding the basic troubleshooting steps to perform if ERROR [S0000] occurs while accessing the SData URL over the web. Refer the below image for ERROR [S0000] [ProvideX][ODBC Driver]PVKIO] Logon failed ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed:

Error [S0000]

As you all know for accessing SData over the web User needs to enter their Sage 100 Login credentials. So in order to resolve the above encountered error one needs ask the “Administrator” or any user with appropriate rights.

Solution/Resolution

User needs to Login to Sage 100 ERP application for identifying the problem with the User used for accessing SData over the web.

Sage 100 ERP Logon

After logging to Sage 100 ERP, open “Library Master Module” located under Modules and click on “User Maintenance” sub-module. As shown in the below image:

User Maintenance in Library Master Module

Clicking “User Maintenance” sub-module, will pop a screen where we need to specify the User Logon Name for accessing SData. Refer the below image:

User Maintenance Screen

Once you have enter the required User Logon all the details of the User [the one used for accessing SData] populates on the screen. The screen also has a checkbox at the left bottom of the screen which says “User Account Locked” with the value as “True” or “Checked” which means the following User Logon: SData is locked.

Since the Account is locked, it will not allow the User to login in Sage 100 ERP application. And it will also not allow the User to access to SData over the web. So in order to remove the barrier of not being able to access the SData and logging into Sage 100 ERP application, the Administrator needs to “Un-check” the box of User Account locked for the “SData” for User to continue its Activities.

Uncheck User Account Locked CheckBox

Conclusion

When the Administrator un-checks the User Account Locked checkbox the user can now access the SData over the web and you can no longer encounter the ERROR [S0000] [ProvideX][ODBC Driver]PVKIO] Logon failed ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed. Refer the below image:

SData Accessibility over the Web

In conclusion, by using the above steps you are able to login & are able to use SData web-service again. If you still have concerns, you can write it to us and we will reach out to you with the same.

We hope you may find this blog resourceful and helpful. If you still have concerns and need more help, please contact us at salesforce@greytrix.com.

About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3, Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support to business partners and end users.
Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our Salesforce products and services, contact us at salesforce@greytrix.com. We will be glad to assist you.

Related Posts