Error received when executing a TPC-D test using an ODBC SQL Server driver:
"ODBC Error (07001,0) - [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error"
WORKAROUND:
Please apply the attached fix to Benchmark Factory 4.7.1:
1) Exit out of Benchmark Factory.
2) Go to the C:\Program Files\Quest Software\Benchmark Factory for Databases\bin directory.
3) Rename the current CTPCD_ODBC.dll file to CTPCD_ODBC.dll.old.
4) Download the attached CTPCD_ODBC.dll file into the C:\Program Files\Quest Software\Benchmark Factory for Databases\bin directory.
5) Relaunch Benchmark Factory and retest the problem.
STATUS:
Fixed in Benchmark Factory for Databases 5.0. Please visit this link to download Benchmark Factory 5.0: http://support.quest.com/Portal/Logon.asp?ReturnURL=/support_download/Downloads.asp.