[unixODBC-dev] Regarding SQLGetFunctions

[G, Hemanth Kumar]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-dev/attachments/20090618/63b0ace3/attachment.html>