sql server programming: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 ) -- sql server programming

DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )

Vodafone
3/14/2006 10:42:55 PM

sql server programming: Hai all,

I am getting an DB_E_ERRORSINCOMMAND exception when I try to open a
recordset or execute query in VC++. But when I run the same query in
Query Analyzer, it is working fine. I am sure the connection string is
correct. I am running a collection of queries and finally commit the
transaction, but everytime it not throwing the exception on same query,

eachtime different queries throw exception randomly.

Can anyone tell whats the problem?
Urgent, Please help...
Looking forward for the response..
Thanx in advance...

Re: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )

Erland Sommarskog
3/15/2006 9:19:42 AM

Vodafone (princevictor.moses@gmail.com) writes:
[quoted text, click to view]

There is answer in comp.databases.ms-sqlserver. Please do not post the
same question independently to several newsgroups.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at