Search: Advanced search
Please enter a keyword or ID
TestTrack ODBC Call Failed Error #1024
Note: The following information only applies to TestTrack 2011.1.3 and earlier.
When querying a Microsoft Access database that links to a TestTrack project, the following error is returned:
ODBC-Call Failed. [Seapine software][TestTrack ODBC Dr (#1024)]
The query is using a date field in the 'Where' clause of the SQL statement. The date field uses Access formatting.
SELECT DEFECTS.DEFECTNUM, DEFECTS.SUMMARY, DEFECTS.DATEENTER
There are two solutions:
The following query prompts you for the start and end dates you want to use each time you run the query:
SELECT Count(DEFECTS.IDRECORD) AS CountOfIDRECORD