Transact SQL – using xp_sscanf to parse input ( Parse Bible Verse )

  Background Let us use xp_sscanf to parse Bible Verse. Introduction Bible people will say my hope rests on John 3:16 An inquiry mind might want to look up John 3:16. In his or her mind, he will break those words down. In computer jargon, one will tokenize it. Tokens Here are the tokens :- … Continue reading Transact SQL – using xp_sscanf to parse input ( Parse Bible Verse )

ODBC – Error – [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

  Background Continuing to review ODBC API calls via C. Ran into a simple error. Error Message - #1 - COUNT field incorrect or syntax error Error Image Error Text Code Code Snippet TroubleShooting Issue The issue is the custNameDataLen variable. Documentation The CustNameDataLen variable map to the BufferLength variable. Microsoft Documentation Links SQLBindParameter Function … Continue reading ODBC – Error – [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

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