Sometimes when users attempt to login, an “A get/change on operation table ‘SY_Pathnames’ failed accessing SQL data” error message pops up as seen below.
When you click on more info, the following error code is shown.
Here’s how you can solve this:
1) Edit your ODBC settings
- Click on Data Sources (ODBC), and click on the System DSN tab: to select the ODBC for PDK, and click on Configure
2) In the Microsoft SQL Server DSN Configuration window.
- Confirm that you are connecting to the correct SQL server and click next
3) Mark the checkbox : “Change the default database to”
￼4) Change the name of the database to ‘DYNAMICS’ in the field for Change the default database to (Note: Both of the checkboxes for the “Use ANSI…” settings should not be marked.)
5) Click Next and Finish.
And there you go! The error will now be resolved and you will be able to log in.
Need GP help? Get worry free Dynamics GP Upgrades and support from the experts at MIBAR. Contact us for more information. Or learn more about Dynamics GP alternatives.
Additional Microsoft Dynamics GP Resources
Reconcile Misaligned Receivables Batch in Microsoft Dynamics GP
Enter, Process and Reconcile Credit Card Transactions in Microsoft Dynamics GP
Voiding Historical Credit Memos in Microsoft Dynamics GP
Expedite Checkbook Register Inquiries in Dynamics GP with Date Restrictions