| | Resolution | Create a 32-bit ODBC DSN - In Windows Search, type CreateDSN, and select the CreateDSN utility.
- The Sage BusinessWorks - Create DSN Utility window opens.
- Select the desired company, or Database ID, from the list.
- Click Create DSN.
- Confirm the server displays "DSN Ready."
- On a client workstation, confirm the system displays "Server and Client Ready."
Recreate an existing DSN after an ODBC failure If the DSN already exists but an ODBC failure occurs, remove the existing DSN entries and recreate them. - Go to C:\Windows\SysWOW64.
- Double-click odbcad32.exe.
- Select the System DSN tab.
- Remove all entries ending with _ODBC.
- Follow the 32-bit ODBC DSN steps above to recreate the DSNs.
Log in to the database The database displays a login and password dialog when you connect. - Enter MANAGER for the login.
- Enter the password associated with your Sage BusinessWorks MANAGER account.
- Enter the password in all capital letters.
Connect using a 64-bit DSN Connect with Crystal Reports 2020 - Crystal Reports 2020 connects only through a 64-bit ODBC driver.
- Install Sage BusinessWorks 2023 or later to use the 64-bit ODBC driver.
- See instructions on creating a 64-bit DSN.pdf when connecting with Crystal Reports 2020.
|
|