ODBC Driver Manager throws function sequence Error

Question

Hi

While connecting to SQL Server from 64 bit OS and 64 bit version of my program and running the following statement i am getting ODBC Driver Manager throws function sequence Error

rc = SQLSetStmtAttr( *pStmtSQLHandle, SQL_ATTR_ROW_BIND_TYPE, SQL_BIND_BY_COLUMN, 0);

But the same functionality works fine when connected from 32 bit OS with 32 bit version of my program

I am connecting to SQL Server 2008

64 bit ODBC Driver gives this error where as 32 bit ODBC driver works fine

any clues/pointer

from
nayeem khan

---

Khan

Answer 1

For setting SQL_ATTR_ROW_BIND_TYPE, please set the 4th argument as the constant SQL_IS_UINTEGER.

But I don't think that this is the root cause of the issue. Since the error message is about "function sequence error", please pay special attention if you are using DAE parameter or ASYNC functionality. Please double-check the return code of previously-called functions carefully.

If the issue can be reproduced easily, please try to capture us a ODBC Trace log or BidTrace log. You can see the detail instruction on MSDN.
I wonder what the OS of the 32-bit OS is, and what is your new OS? Win7?


Thanks,
Ming.
WDAC Team, Microsoft.

---

Pak-Ming Cheung - MSFT