value of SQLSTATE

[Sivagami]

Hi all,

I am trying to access SQL Server 6.5 with ODBC 2.0 in C++.
I use SQLGetData command to pull data from the table. This command returns SQL_SUCCESS or SQL_ERROR based on the record. When I try to view the value of SQLSTATE when it is SQL_ERROR, it shows '00000', implying it is a success, but my SQLGETDATA command gives an error.
Does anyone know what is happening??

Shiva.

 

[vasanthgnb]

try this one. make use of a byte array to get the sqlstates returned from the SQL_ERROR function. If u don't mind mail ur code to vasanthgnb@yahoo.com. i'll try to help u out. ur code 'll be kept confidential to the max extent.

 

[vasanthgnb]

i just made an error in my former reply. make use of the function SQRERROR to get the value of SQLSTATE. make use of a byte array to get the returned value of SQLERROR