Can anyone Please explain the Function SQLSetConnectOption

[d_siva_raman]

Hi please explain the Function which is called with the Following parameter:

SQLSetConnectOption(*hdbc, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC);

[NoHero]

SQLSetConnectOption (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlsetconnectoption.asp) is deprecated use SQLSetConnectAttr (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlsetconnectattr.asp) instead.

[kkez]

Hi please explain the Function which is called with the Following parameter:

SQLSetConnectOption(*hdbc, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC);
Where does that code come from? The SQLSetConnectOption function is deprecated (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlsetconnectoption.asp) and you should use SQLSetConnectAttr instead.

EDIT: lol, hi NoHero :P