Error: General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datatime data type resulted in an out-of range value. Native error:242-when reprinting Receipts

User may see the following error message when reprinting a receipt directly from a Gift Record:

General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion or a varchar data type to a datatime data type resulted in an out-of-range value.
Native Error:242.
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
Native error: 16945.

This error occurs only when the regional settings on the workstation are set to English (Canada).

If the database is hosted by Blackbaud Hosting Services, this error occurs only when the Regional Settings in Blackbaud Hosting Services are set to English (Canada).
This was resolved in Raiser's Edge 7.96, patch 1, released and applied to databases in Blackbaud Hosting Services in fall 2016. 

If your Raiser's Edge is not hosted by Blackbaud (self-hosted/locally installed): Download and install the Raiser's Edge 7.96 patch 1, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

An alternate solution is to change the regional settings on the workstation from English (Canada) to English (United States):

1. On the workstation, select Start>Control Panel.
2. Click Region and Language.
3. In the Format field, select English (United States).
4. Click OK.

Alternate solution if Hosted is to change the regional settings in Blackbaud Hosting Services:

1. Log into Blackbaud Hosting Services.
2. Click to launch Regional Settings.
3. In the Format field, select English (United States).
4. Click OK.
 

Steps to Duplicate

1. Set regional settings to English (Canada).
2. Log into the Raiser's Edge.
3. Open the Constituent record.
4. Select the Gifts tab.
5. Open the Gift record that will need a reprinted receipt.
6. Select Gift>Reprint Receipt.
7. Enter Receipt Action=Reprint.
8. In the Use this Parameter file field, Search to include the Receipt parameter file.
9. In the Receipt number to use field, select Same.
10. Click Export.
11. In the Export File Type, select Rich Text Format (RTF).
12. Click Export Now. Error Message Appears.
 

Was this article helpful?