CODEWITHSUNDEEP
sql-serverdatabaseodbc
Kartikey Chawla
Kartikey Chawla

Reputation: 101

ODBC 4 and ODBC Driver 17

I want to check if ODBC 4 (https://github.com/microsoft/ODBC-Specification) and ODBC 17 Driver (msodbcsql17.dll) are interlinked or ODBC Driver 17 supports the queries for ODBC 4. Any link or help will be appreciated. P.S.:- ODBC 4 was rolled out in 2016 and ODBC 17 in 2017.

Upvotes: 0

Views: 271

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123399

Using pyodbc to ask the driver what version of ODBC it supports, the driver replies with ODBC version 3.8:

print(f'driver: {cnxn.getinfo(pyodbc.SQL_DRIVER_NAME)}, version: {cnxn.getinfo(pyodbc.SQL_DRIVER_VER)}')
# driver: msodbcsql17.dll version 17.04.0001

print(f'driver ODBC version: {cnxn.getinfo(pyodbc.SQL_DRIVER_ODBC_VER)}')
# driver ODBC version: 03.80

Upvotes: 1

Related Questions