This issue typically occurs when you have mismatch in architecture - specifically where the bitness of the installed database driver does not match the configured bitness of the DSP application (32 vs 64). To correct the issue, ensure that all the following are either 32 bit or 64 bit. No mixed architecture configurations are supported.
- The DSP background Service (aka CranSoft Service)
- The DSP application pool (in IIS)
- The ODBC driver
- The DSN (Data Source Name)
If the bitness of the above are found to be inconsistent, then this must be resolved. In the case of (1) and (2) see the DSP installation guide appendix for details on configuring the architecture. In the case of drivers/DSN, a new driver will need to be installed and the old one removed. Check driver documentation for details.
To check the DSP (CranSoft) Service (or Services) architecture:
1. Make a remote desktop connection to the DSP application server.
2. Run the Control Panel > Administrative Tools > Services program.
3. Select an entry beginning with "CranSoft Service".
4. Right-click and select Properties.
5.Review the Path to executable value on the General tab.
If it contains CranBerryService64.exe, then it's 64-bit.
If it contains CranBerryService.exe, then it's 32-bit.
6. Repeat steps 3-5 for any other services that begin with "CranSoft Service".
To check the DSP application:
1. Make a remote desktop connection to the DSP application server.
2. Run the Control Panel > Administrative Tools > Internet Information Services (IIS) Manager program.
3. Expand the server node in the Connections panel on the left.
4. Click Application Pools.
5. Right-click the DSP application pool and select Advanced Settings.
NOTE: The application pool name was set during initial installation of the DSP.
6. Review the Enable 32-Bit Applications setting in the General section.
If set to False, then 64-bit.
If set to True, then 32-bit.
To check the DSN:
1. Make a remote desktop connection to the DSP application server.
2. Run the C:\Windows\System32\odbcad32.exe program.
3. Click the System DSN tab.
4. Select your DSN.
If you can't find it, then the driver is 32-bit only (or possibly missing).
5. Review the Platform value.
6. Run the C:\Windows\SysWOW64\odbcad32.exe program.
7. Click the System DSN tab.
8. Select your DSN.
If you can't find it, then the driver is 64-bit only (or possibly missing).
9. Review the Platform value.
To check the ODBC driver:
1. Make a remote desktop connection to the DSP application server.
2. Run the C:\Windows\System32\odbcad32.exe program.
3. Click the System DSN tab.
4. Select your DSN.
5. Note the Driver value.
6. Click the Drivers tab and look for a record whose Name value matches step 5.
If you can't find it, then the driver is 32-bit only (or possibly missing).
If you can find it, then the driver is compatible with 64-bit DSN.
7. Run the C:\Windows\SysWOW64\odbcad32.exe program.
8. Click the Drivers tab and look for a record whose Name value matches step 5.
If you can't find it, then the driver is 64-bit only (or possibly missing).
If you can find it, then the driver is compatible with 32-bit DSN.