Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Beginner
Aug 6, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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]
Attach the SQL Server table and open a record set on the attached table to solve the problem.

Do not use the OpenDatabase method to open the record set while a transaction is pending. SP_STATISTICS, a catalog stored procedure, retrieves information about the table on which you create the record set. SQL Server does not allow this stored procedure to run while a transaction is pending.

Douglas Haynes
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date