Within the GIFTS system, when using a Microsoft SQL Server or Microsoft Access database back end, administrators may receive a message similar to one of the following when creating new fields with the GIFTS Customizer:
Error occurred during table creation Error occurred while executing SQL Statement: [XXX] Technical Support Info: [SQLExecute] Error #-2147217900 Syntax error in field definition Technical Support Info: [SQLExecute] Error #-2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'xxx'
The reason for this behavior is tied to the fact that Microsoft SQL Server and the ODBC drivers that your GIFTS workstations use to communicate with your SQL Server database both reserve words for use in administering database information. These keywords are also reserved for use by Microsoft Access.
There is not a true resolution to this behavior due to the restrictions imposed by Microsoft, we would simply suggest that the field names that you create for use with the GIFTS Customizer not contain any of the words reserved by SQL Server; use of these words in your Customizer field names may interfere with the proper operation of GIFTS. Please review the Microsoft Article below for a comprehensive list of reserved keywords for SQL Server 2012:
As always, if the above issue persists even when following this suggestion, please contact us with the customer support number for GIFTS listed at https://www.blackbaud.com/contact-us/ which will always have the most up to date information,