Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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 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.

 

 

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