Re: odbc.e and SQL return codes
- Posted by Rad <radhx at rediffmail.com> Feb 02, 2006
- 402 views
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.