1. Re: odbc.e and SQL return codes
Hi Matt,
I checked out MSDN and following are the observations:
sqlstate is 5 character field, which may not always have numeric data.
e.g. timeout expired: HYT00
As in odbe.e we are getting the value() of error, may be that's what is
giving the zeros as result.
follwoing is the link from msdn to sqlstate codes:
For a complete list of SQLSTATEs and what functions return them,
see Appendix A: ODBC Error Codes.
For a detailed explanation of the conditions under which each function
might return a particular SQLSTATE, see that function.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_error_codes.asp
This list of sqlstates will also help me to code my program accordingly.
Regards,
Rad.
