Re: Stored Procedure calls from Cognos Impromptu

At 08:09 09/25/2002, you wrote:

We are trying to call an AS400 stored procedure from Cognos Impromptu and
getting a "read-only" error. We are using the Client Access ODBC driver. We
think that the driver is the problem because we monitor all SQL activity on
the AS400 and the monitor is not seeing the request. Am I missing something?
Is there a way to configure the driver for something other than "read-only"?

I have no idea if this will help, but I did have a similar problem back in
the fall of 1999 relating to Seagate Crystal Info, and it was cured by
adding a string value named "AllowProcCalls" with a value of "1" to the
ODBC driver entry in the registry (Either HKEY_CURRENT_USER or
HKEY_LOCAL_MACHINE, depending on whether it's a user or machine data
source) \Software\ODBC\ODBC.INI\<datasourcename>. This is from an IBM
technical document number 10282349 entitled, interestingly, "Undocumented
ODBC Options". The product is CLIENT ACCESS/WINDOW (5763XC100); CA400 WIN95
(5763XD100), Keywords: ODBC.

The text for "AllowProcCalls=0" says "Stored procedures can not be called
when the connection access mode is set to read-only (default=0). Available
with Express V4R4M0 and above, V3R2M0 will add this support with service
pack 6, V3R1M3 will add this support with service pack 9."


Pete Hall
pbhall@ameritech.net
http://www.ameritech.net/users/pbhall/index.html