devxlogo

Avoid an ODBC Error Referencing SP_Statistics

Avoid an ODBC Error Referencing SP_Statistics

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.

devx-admin

Share the Post: