RE: Stored Procedure calls from Cognos Impromptu

Hi Pete

Thanks for the info. That worked, or at least got me past the first hurdle.
We're talking to the AS400. Now to figure out what it's saying.

Gord

-----Original Message-----
From: Pete Hall [mailto:pbhall@ameritech.net]
Sent: Wednesday, September 25, 2002 8:25 PM
To: midrange-l@midrange.com
Subject: 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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.