ODBC – API – SQLBindParameter – Date, Time – Timestamp – Error Messages

Background Wanted to highlight a few less than intuitive error messages one can run into when trying to work on dates using the SQLBindParameter. BTW,  our programming language is C and ODBC. Code 1) DATE_STRUCT // SQL_C_TYPE_DATE // SQL_TYPE_DATE Code Output 2) SQL_TIMESTAMP_STRUCT // SQL_C_TYPE_TIMESTAMP // SQL_TYPE_TIMESTAMP Code Output 3) SQL_TIMESTAMP_STRUCT // SQL_C_TYPE_TIMESTAMP // SQL_TYPE_TIMESTAMP … Continue reading ODBC – API – SQLBindParameter – Date, Time – Timestamp – Error Messages

ODBC – SQLBindCol Function – Using Microsoft’s sample code – Code Review

Background A quick follow-up to our original post on using the ODBC SQLBindCol function. Lineage ODBC – SQLBindCol Function – Using Microsoft’s sample code Date Published :- 2020-01-01 Link Microsoft Sample Web Site Tried out Microsoft's sample; available here. Docs / SQL ODBC / ODBC Advanced / Microsoft Open Database Connectivity (ODBC)/  ODBC Programmer's Reference … Continue reading ODBC – SQLBindCol Function – Using Microsoft’s sample code – Code Review

ODBC – SQLBindCol Function – Using Microsoft’s sample code

Background Reading more on ODBC via C. Microsoft Sample Web Site Tried out Microsoft's sample; available here. Docs / SQL ODBC / ODBC Advanced / Microsoft Open Database Connectivity (ODBC)/  ODBC Programmer's Reference / API Reference / ODBC API Reference / SQLBindCol Function SQLBindCol Function Link Compile Tried compiling the code. Output Image   Text … Continue reading ODBC – SQLBindCol Function – Using Microsoft’s sample code