BUG: Function Sequence Error Not Returned for Transactions When Connection Pooling Is Disabled (294149)

MORE INFORMATION

Steps to Reproduce Behavior

1. From Query Analyzer, run the following code to create the table "sytest":

   if exists (select * from sysobjects where id = object_id(N'[dbo].[sytest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
      drop table [dbo].[sytest]
      GO
   
   create table sytest(col1 int)
   insert into sytest Values(1)
   insert into sytest Values(2)
   insert into sytest Values(3)
   					

2. Create a new Win32 console application and paste the following code in your project:

   #include <windows.h>
   #include <sql.h>
   #include <sqlext.h>
   #include <stdio.h>
   
   int StmtError(HSTMT);
   
   void main(void)
   {
       SQLHENV henv;
       SQLHDBC hdbc;
       SQLHSTMT hstmt;
       SQLRETURN nstatus;
       SQLCHAR szConnect[1024];
   
       // Enable connection pooling.
       nstatus = SQLSetEnvAttr(NULL,SQL_ATTR_CONNECTION_POOLING,(SQLPOINTER)SQL_CP_ONE_PER_DRIVER,SQL_IS_INTEGER);
       nstatus = SQLAllocHandle(SQL_HANDLE_ENV,NULL,&henv);
       nstatus = SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER) SQL_OV_ODBC3,0);
       nstatus = SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);
   
       for (int i=0;i<=10;i++)
       {
   	nstatus = SQLDriverConnect(hdbc,NULL,(unsigned char *)"DSN=toCaveman;UID=sa;PWD=Password1;", 
   		SQL_NTS, szConnect, 256, NULL, SQL_DRIVER_NOPROMPT);
   
   	nstatus = SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt);
   	nstatus = SQLExecDirect(hstmt,(SQLCHAR*) "select col1 from sytest",SQL_NTS);
   	nstatus = SQLFetch(hstmt);
   	nstatus = SQLSetConnectAttr(hdbc,SQL_ATTR_AUTOCOMMIT,(void *)SQL_AUTOCOMMIT_OFF,0);
   	nstatus = SQLTransact(henv,hdbc,SQL_COMMIT);
   	nstatus = SQLSetConnectAttr(hdbc,SQL_ATTR_AUTOCOMMIT,(void *)SQL_AUTOCOMMIT_ON,0);
   	nstatus = SQLFetch(hstmt);
   	
   	if(nstatus == SQL_ERROR)
   	{
   	StmtError(hstmt);   
   	}
   	
   	nstatus = SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
   	nstatus = SQLDisconnect(hdbc);
       }
   
       nstatus = SQLFreeHandle(SQL_HANDLE_DBC,hdbc);
       nstatus = SQLFreeHandle(SQL_HANDLE_ENV,henv);
   
       printf("Done");
   } 
   
   StmtError(HSTMT hstmt)
       {
       // Variables for SQLDiagRec.
       RETCODE rc = 0;
       char mstate[6] = "\0";
       long native = 0;
       char mtext[300] = "\0";
       short mlength = 0;
       short i = 0;
   
       while ((rc = SQLGetDiagRec(SQL_HANDLE_STMT, hstmt, ++i, (unsigned char *)&mstate, 
      		&native, (unsigned char *)&mtext, 300, &mlength)) != SQL_NO_DATA)
           printf("\nODBC Error:\t%s\n",mtext);
   
       return(0);
       };
   					

3. Change the connection string to use your database and server.
4. Compile and then run the code. On the second iteration, you should receive the following error in the console window:
   [Microsoft][ODBC Driver Manager] Function sequence error
5. Comment out the line of code where SQLSetEnvAttr is called to enable the connection pooling.
6. Recompile and run the code. You should not see any errors.