All geek questions in one place

ODBC 11 driver for SQL Server and SQLGetData constraints

The SQLGetData Function link explains the following general API limitation:

If the driver does not support SQLGetData extensions, the function can only return data for unrelated columns with a number greater than that of the last associated column. In addition, within the data series, the value of the Col_or_Param_Num argument in each SQLGetData call must be greater than or equal to the Col_or_Param_Num value in the previous call; that is, data must be obtained in an increase in the column order number.

Article description ODBC API implementation to SQLGetDataadd information specific to SQL Server Native Client driver:

The SQL Server Native Client ODBC driver does not support using SQLGetData to retrieve data in random column order. All unrelated columns processed using SQLGetData must have higher column numbers than the related columns in the result set.

Does this limit column ordering to the new Microsoft recommended ODBC driver for SQL Server ?

Is there a difference in this behavior between the current ODBC Driver 11 for SQL Server version and the upcoming ODBC Driver 13 (Preview) version for SQL Server?

+2
source share
1 answer

You can test driver capabilities from code by calling the SQLGetInfoODBC function .

ODBC 13 SQL Server :

SQL_GETDATA_EXTENSIONS:
        SQL_GD_ANY_COLUMN false
        SQL_GD_ANY_ORDER false
+2

Source: https://habr.com/ru/post/1650375/

More articles:


All Articles