Has anyone tried programming against Cisco Unity Connection 7 using the Informix client libraries?
I am trying to call Csp_SubscriberCreate but I get back an error -937 from the Informix client libraries. This seems to be related to the subscribercreate stored procedure returning two parameters as I can successfully call csp_subscribermodify and csp_subscriberdelete. I am sure that the data that I am sending to the procedure is correct because I have tested with CUDLI - It seems to be an issue with the Informix client libraries and the multiple return from this stored procedure.
Has anyone else tried this? Does anyone have any suggestions?
So can you give a little more detail on what you're doing? Are you working in .NET? ADO? How are you setting up the call? Are you using the Informix .NET wrappers or are you using the ODBC drivers "straight" (i.e. installed off my site)?
I've had a number of sites use this and I use it myself without any issue - all the create procs should return a data reader (in the case of ADO.NET) or a recordset (in the case of ADODB) - the number of items (columns) shouldn't matter. The first return item should be the ObjectID of the newly created object.
If you're using the .NET wrappers from IBM's download site directly, I'd suggest not doing that - I use the straight ODBC method and it works fine (I have apps in both .NET and ADODB). For .NET I'm using simple command text construction and using the "ExecuteReader" method off a command object and assigning the output to a reader for review (if the reader is nothing then the proc failed).
Nothing too unusual - really the only trick to the Informix stuff is their lvarchar param needs special handling but other than that it's pretty straight forward.
If you let me know what you're doing, perhaps a small code chunk I can try and see what's going on.