Re: Transaction getting stuck in SQLBindCol
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Fri, 18 Mar 2011 17:37:12 +0000 Matthew Gates <[email protected]> wrote: > When SQLBindCol is called, is any connection to the database required which might be blocking due to a sporadic network issue? Where else might a problem lie? SQLBindCol() provokes no network activity. It simply tells the library the form in which it wants to see the data, and about the buffer into which the transformed data are to be placed. There's hardly even a loop. The only one I see is on the error path (always ripe for problems) in odbc_get_msg(). If you're convinced the SQLBindCol() isn't returning, I'd write a tiny log recording the entry and exit of it and the funcitions it calls: IS_VALID_LEN ODBC_RETURN ODBC_RETURN_ desc_alloc_records odbc_errs_add odbc_set_concise_c_type tdsdump_log HTH. --jkl