Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013

    Unanswered: nformix Error - The selected ACCEPTKEY has been pre-assigned for ISQL

    I have a C# application that uses an ODBC connection and when I execute a certain procedure call I get the ACCEPTKEY error back.

    When I use Cisco's CUDLI tool to execute the same procedure it works fine. Only when I use the ODBC connect in my C# code the store procedure fails during execution and reports an error. Error - "The selected ACCEPTKEY has been preassigned for ISQL"

    This is the full error that I get back:
    ERROR [HY000] [Informix][Informix ODBC Driver][Informix]The selected ACCEPTKEY has been pre-assigned for ISQL sqlerrm(Object not found. Object = [Credential], Table = [tbl_Credential], Colu)

    When I look up the Error on IBMs Information Center, it says:

    -1004 The selected ACCEPTKEY has been preassigned for ISQL.
    The key that the ACCEPTKEY environment variable specifies is one that
    IBM Informix SQL always uses. Set a different value in the environment

    I have no clue what it is talking about or what to change.

    Any help would be greatly appreciated.

  2. #2
    Join Date
    Sep 2011
    Pont l'Abbé, Brittany, France
    Provided Answers: 1

    did you check what env variables you have for the session launching C# ?
    Same in your ODBC driver, no variables set ?
    Which version of ODBC are you using against which version of Informix ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts