Incorrect syntax near a keyword
| Article:HOWTO2745 | | | Created: 2006-03-14 | | | Updated: 2006-08-21 | | | Article URL http://www.symantec.com/docs/HOWTO2745 |
Problem
When clicking on a sample job/event, the following error occurs:
Incorrect syntax near the keyword 'Group'.
Line 1: Incorrect syntax near ')'.
Line 1: Incorrect syntax near ')'.
The ORDER BY position number 2 is out of range of the items in the select list.
Statement(s) could not be prepared.
Environment
Deployment Solution 6.9 SP1, SP2, SP3, SP4
Cause
Incorrect ODBC settings.
Resolution
1. Go to the ODBC settings in Control Panel under Administrative Tools.
2. Open the ODBC Data Source Administrator window and click on the system DSN tab.
3. Highlight "Altiris eXpress Database", and click on Configure.
4. Click Next through the next two screens and make sure that "Use ANSI quoted Identifiers" and "Use ANSI nulls, paddings and warnings" are checked.
Putting a check mark by both of these boxes will solve the issue.
2. Open the ODBC Data Source Administrator window and click on the system DSN tab.
3. Highlight "Altiris eXpress Database", and click on Configure.
4. Click Next through the next two screens and make sure that "Use ANSI quoted Identifiers" and "Use ANSI nulls, paddings and warnings" are checked.
Putting a check mark by both of these boxes will solve the issue.
Legacy ID
20644
Article URL http://www.symantec.com/docs/HOWTO2745
Terms of use for this information are found in Legal Notices
Thank you.