"A database error has occurred while performing an operation. (MicrosoftODBC Driver Manager Datasource name not found and no default driver specified: Server: Server Name; dB: Name))" occurs when launching or in various tasks in Sage BusinessWorks.  Another variation of the error is " WARNING: An error has occurred while attempting to synchronize the System Manager. Data source name not found and no default driver specified."

The program is unable to access the ODBC driver.

 CAUTION: This solution requires advanced knowledge of your computer's operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage isn’t responsible for operation issues caused by incorrectly modifying your Windows Registry.  

The database engine is damaged

1. Uninstall the database engine on the computer receiving the error.
2. Reinstall Sage BusinessWorks from the original installation medium.
   • Reinstall at a server or standalone computer. Use the install file in the C:\Sage BusinessWorks 20xx Install Files (where xx is the software year)
   • Reinstalling at the workstation, use the install file in \\server\sage\bwprog\client setup\autorun.exe
   • Reinstall the most current Service Pack

Damaged ODBC DSN driver or pointing to the wrong server

1. 1. Remove all DSNs related to Sage BusinessWorks.
   2. Create all DSNs related to Sage BusinessWorks.

Verify user has sufficient rights in Windows

• 1. In Windows, assign local administrative rights to the user.
  2. Give the C:\Windows folder full control permissions to the local administrator group and the system group.

Verify user rights in the Windows registry

1. 1. On the Windows Start menu, click Run.
   2. Type Regedt32 and click OK. to open Registry Editor.
   3. Expand HKEY_LOCAL_MACHINE, SOFTWARE, SOFTWARE, then ODBC.
   4. In the ODBC key, assign full control rights to the local administrator group and the system group.

Ensure each Terminal Server user has installed the Client setup

Each user accessing the Sage BusinessWorks program in a Remote or Terminal Server session, must install the Client setup while logged into a session.

• Log in to user sessions and install BWProfile.