After opening a record set on a SQL server, this ODBC error occurs:
ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server] (#20001)
Attach the SQL Server table and open a record set on the attached tableto solve the problem.
Do not use the OpenDatabase method to open the record set while a transactionis pending. SP_STATISTICS, a catalog stored procedure, retrieves informationabout the table on which you create the record set. SQL Server does notallow this stored procedure to run while a transaction is pending.