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.

Personal Data Keeper SQL Data

When you click on more info, the following error code is shown.

Personal-Data-Keeper-Error

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
ODBC Data Source

2) In the Microsoft SQL Server DSN Configuration window.

  • Confirm that you are connecting to the correct SQL server and click next

Microsoft SQL Server DSN Configuration

3) Mark the checkbox : “Change the default database to” 

Microsoft SQL Server Default

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.)

Microsoft SQL Server Change Default

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. 

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