Re: CREATE PROCEDURE

Perfect Vern... Thanks, but that only gets me to the next error message:

'Error opening file. There are no fields in the file: "SYS.Lib.Proc(Test)".

U gots any other useful info?


Ken Slaugh (707) 795-1512 x118
Chouinard & Myhre, Inc.
CA/400 Certified Specialist
iSeries Network/MSE Administrator
http://www.cm-inc.com/


                                                                                
                                    
                    Vern Hamberg                                                
                                    
                    <vhamberg@xxxxxxxxxxxxxxxx        To:     Midrange Systems 
Technical Discussion                 
                    ology.com>                        <midrange-l@xxxxxxxxxxxx> 
                                    
                    Sent by:                          cc:                       
                                    
                    midrange-l-bounces@xxxxxxx        Subject:     Re: CREATE 
PROCEDURE                             
                    e.com                                                       
                                    
                                                                                
                                    
                                                                                
                                    
                    02/19/2003 10:15 AM                                         
                                    
                    Please respond to Midrange                                  
                                    
                    Systems Technical                                           
                                    
                    Discussion                                                  
                                    
                                                                                
                                    
                                                                                
                                    




Found this at Crystal's site, in
<http://support.crystaldecisions.com/library/kbase/articles/c2008274.asp>

IBM has an undocumented registry setting that is required when using
Crystal Reports to call DB2 Stored Procedures on an AS/400 using the IBM
Client Access Express ODBC drivers.

This setting is specified in the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<-my dsn->, must be added as
AllowProcCalls=1.

The same would apply to any user DSNs, so also look at
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<-my dsn->, must be added as
AllowProcCalls=1.

HTH

Vern

At 08:47 AM 2/19/2003 -0800, you wrote:
>Has anyone created and procedure with SQL on the iSeries and successfully
>used it in ODBC? Here's the message I'm receiving from Crystal Reports...
>
>'ODBC Error: [IBM] Client Access Express ODBC Driver (32-bit) Statement
>violates access rule: Connection is set to read only.'
>
>I've tried many different combinations of settings within ODBC properties
>and don't seem to get a combination that works.
>
>
>Ken Slaugh (707) 795-1512 x118
>Chouinard & Myhre, Inc.
>CA/400 Certified Specialist
>iSeries Network/MSE Administrator
>http://www.cm-inc.com/


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