Regarding SQLGetFunctions

Nick,

        Our Teradata driver does not support SQLSetScrollOptions.
But when checked using SQLGetFunctions(), it says it is supported.

I speculate, SQLGetFunctions is not getting called from the driver.
Instead, the information is coming from the driver manager itself.

I set the SQL_CUR_USE_IF_NEEDED attr in SQLSetConnectAttr to
SQL_CUR_USE_DRIVER, so as to confirm that SQLGetFunctions is getting
called from the driver. But, I think, the information is getting
returned from driver manager's SQLGetFunctions itself.

unixODBC DM
------------------------------------------------------------------------
---------------------------
- using SQL_CUR_USE_ODBC
SQLSetConnectOption(hdbc, SQL_ATTR_ODBC_CURSORS, SQL_CUR_USE_ODBC);
SQLGetFunctions(hdbc, SQL_API_SQLSETSCROLLOPTIONS, &isSupported);
isSupported Expected: SQL_TRUE
isSupported Received: SQL_TRUE

- using SQL_CUR_USE_DRIVER
SQLSetConnectOption(hdbc, SQL_ATTR_ODBC_CURSORS, SQL_CUR_USE_DRIVER);
SQLGetFunctions(hdbc, SQL_API_SQLSETSCROLLOPTIONS, &isSupported);
isSupported Expected: SQL_FALSE
isSupported Received: SQL_TRUE
------------------------------------------------------------------------
---------------------------

Microsoft DM
------------------------------------------------------------------------
---------------------------
- using SQL_CUR_USE_ODBC
SQLSetConnectOption(hdbc, SQL_ATTR_ODBC_CURSORS, SQL_CUR_USE_ODBC);
SQLGetFunctions(hdbc, SQL_API_SQLSETSCROLLOPTIONS, &isSupported);
isSupported Expected: SQL_TRUE
isSupported Received: SQL_TRUE

- using SQL_CUR_USE_DRIVER
SQLSetConnectOption(hdbc, SQL_ATTR_ODBC_CURSORS, SQL_CUR_USE_DRIVER);
SQLGetFunctions(hdbc, SQL_API_SQLSETSCROLLOPTIONS, &isSupported);
isSupported Expected: SQL_FALSE
isSupported Received: SQL_FALSE
------------------------------------------------------------------------
---------------------------

Can you verify this once..

Thanks
Hemanth.

_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev