none
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
    Tuesday, March 09, 2010 5:42 AM

Answers

  • 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
    Thursday, March 11, 2010 3:28 PM
    Answerer