A client has set up an ODBC connector to their DB2 database and requested my (existing) program call a proc they've defined. From my perspective, everything is working perfectly. Not so from their point of view. Turns out that their Proc is not receiving the variable's I'm passing in. If they hard-code the variables, I receive the return value and all is well. If their proc attempts to actually use the variables, then they are null. They've also (intermittently) reported seeing an error: 'CLI0110E Invalid output or Indicator buffer specified.'.
I have no recent experience with DB2 and no prior experience with ODBC in conjuction with DB2. I also don't have any direct access to the machine running my program.
Given that error message, I've spent some time fiddling with the SQLBindParameter and trying different values for the fParamType parameter and any others that seems significant. My existing code works quite nicely with MSSQL, Oracle, Centura, and even Excel, which, of course, means absolutely nothing in reguards to DB2, but still leads me to think I'm not doing something totally stupid here.
I would be thrilled if someone could offer some experience/thoughts/links to something that might give me a clue as to why their proc isn't seeing the data I'm attempting to pass.
Thanks,
Adam