FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Rattan, Neeta S wrote:
> As it turns out, I had a problem with an earlier call, the
> SqlAllocHandle() was returning an error that I wasn't catching until I
> started going line by line with the error handling and there was no
> problem with the SqlDriverConnect() line at all.

If I may offer some advice, I have found with this kind of programming
it's especially important to check every function for errors.  When I'm
writing new code in a hurry, if I don't want to specify user friendly
error-checking, I use assert(3) so at least my program dies and I know
which line it was on.  That's much better than trying to figure out why
the *next* function is failing.  ;-)  

Even the error handler can have errors, so:

        ret = SQLGetDiagField(hType, handle, 0, SQL_DIAG_NUMBER, &ndiag,
sizeof(ndiag), NULL);
        assert(ret == SQL_SUCCESS);

Just a friendly suggestion, of course.  

Regards, 

--jkl