query notification

could someone pls tell me the version requirements for开发者_如何学Python query notification? we are running sql server 2008 and use ODBC 3.0 but are still on visual studio 6. on compile some of the ODBC parameter (ex: SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS) are not found. any help would be greatly appreciated. thanks in advance, Bill Riggio

I think you'll need to upgrade to the SQL Server Native Client driver (download here) to take advantage of query notification. Per Microsoft documentation here:

The SQL Server Native Client ODBC driver supports query notifications through the addition of three new attributes to the SQLGetStmtAttr and SQLSetStmtAttr functions:

SQL_SOPT_SS_QUERYNOTIFICATION_MSGTEXT SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS SQL_SOPT_SS_QUERYNOTIFICATION_TIMEOUT