Skip to main content

Practice Management: Error: ODBC--connection to 'aps_dsql' failed finding Server Version.

Updated over a month ago

ODBC--connection to 'aps_dsql' failed

The error is encountered running the version control, followed by the error DATABASE (dbname: aps_dsql) UPGRADE VERSION ERROR.

ODBC and DSN has been found to be correct.

If you are using Microsoft office 64 bit on the computer where you are running version control, you will need to set up a 64bit ODBC connection to run the version control.

  1. Rename the current 32-bit ODBC connection to a different name.

    • 32bit odbc connection file name C:\Windows\SysWOW64\odbcad32.exe

  2. Create another ODBC connection for 64 bit

    • 64bit ODBC file name:C:\Windows\System32\odbcad32.exe

  3. Delete or rename the 64-bit ODBC connection after the version control process.

  4. Revert the 32-bit ODBC connection to its original name once the version control task is completed.

Did this answer your question?