• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1862
  • Last Modified:

"SQLGetDiagRec Failed" in SQL Server...

Hi all, I got the message "SQLGetDiagRec Failed" in SQL server 2005. From what I found from Internet, SQLGetDiagRec is an ODBC functions to return the status of diagnostic records that contains error, warning, or status information. But I do not use this function in my Stored Proc (SP). There is a part in my SP that has a cursor loop and inside the cursor loop I do some freetext search. I suspect this error is occured somewhere within this cursor loop.

Does anyone of  you have any idea on this message? How it happens? And how to resolve or avoid this?

Thanks in advance and any help would be greatly appreciated!
0
IxCraZee
Asked:
IxCraZee
1 Solution
 
twoboatsCommented:
This is internal to the ODBC layer. It's not happening in the stored proc, unless your stored proc is using ODBC to access a datasource external to SQL.

Is there anything in the SQL server log relating to this - there may be more info there that will help diagnose the problem
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now