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

ODBC – Error – “Error :(‘IM002’, [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)”

Error Error Image Error Text Source Code Python Outline Prepare ODBC Connection String Pass ODBC Connection String to module pyodbc, connect method Code TroubleShooting ODBC ODBC Manager Issued ODBC Manager (%windir%\syswow64\odbcad32.exe) and reviewed the list of ODBC Drivers Image Explanation Noticed that the following ODBC Drivers are listed for SQL Server :- ODBC Driver 13 … Continue reading ODBC – Error – “Error :(‘IM002’, [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)”

Linux :- ODBC / SQL Server – Configuration

Background On our Linux box, wanted to configure a Database Source to a SQL Server Instance. Lineage In a previous post, we installed SQL Server Command Line Tools and ODBC Development Tools. That post is :- SQL Server On Linux – Installing Command Line Tools Link ODBC Manager Here are some of the ODBC Managers … Continue reading Linux :- ODBC / SQL Server – Configuration