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 variable.
I have no clue what it is talking about or what to change.
Any help would be greatly appreciated.