Keeping track of the many things learned while working on the ODBC driver.
I followed the instructions to install the ODBC driver here.
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools18
In CLion, I added DBUILD_ODBC_DRIVER=1
to CLion - Settings - Build,Execution,Deployment - CMake - CMake options
.
Then, select test_odbc
from the Run/Debug Configurations
to run the tests. To run a specific test, click on test_odbc
, then Edit Configurations
and add the name of the test as the program's argument, e.g. "Basic ODBC usage"
.
Alternatively, here are more instructions on how to use/fix ODBC (tests).
What are handles
SQLHANDLE
: can be any handle- there are five types of handles, e.g., statement handles
- functions can therefore contain the specific type of the handle:
SQLHANDLE handle, SQLSMALLINT handle_type
HSTMT
: statement handle
- What is an
SQLHANDLE
? - What is a
HSTMT
? I am assuming that this is short for handle-statement?
We often use handles, which are mostly pointers to memory locations.
HSTMT
: points to the metadata and the data of a statementSQLHANDLE
: points to the data of a statement