|
Home > Archive > MS SQL Server > March 2006 > DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
|
|
| Prince 2006-03-15, 3:23 am |
| 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...
| |
| John Bell 2006-03-15, 3:23 am |
| Hi
Have you printed out the SQL Statement before you send it to the server? You
may want to use SQL Profiler to see what/if anything is being sent to the
server.
Have you also checked out
http://support.microsoft.com/defaul...kb;en-us;18189?
John
"Prince" wrote:
> 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...
>
>
| |
| Prince 2006-03-15, 3:23 am |
| Hai,
Thanx for ur reply...
In ran the query from Profiler, it works fine... and the URL that u
provide doesnt works...
Looking forward for the response...
John Bell wrote:
[color=darkred]
> Hi
>
> Have you printed out the SQL Statement before you send it to the server? You
> may want to use SQL Profiler to see what/if anything is being sent to the
> server.
>
> Have you also checked out
> http://support.microsoft.com/defaul...kb;en-us;18189?
>
> John
>
> "Prince" wrote:
>
| |
| John Bell 2006-03-15, 3:23 am |
| Hi
Try http://support.microsoft.com/kb/181890
You may want to check MDAC versions.
John
"Prince" wrote:
> Hai,
>
> Thanx for ur reply...
> In ran the query from Profiler, it works fine... and the URL that u
> provide doesnt works...
> Looking forward for the response...
>
>
> John Bell wrote:
>
>
>
|
|
|
|
|