This is kind of odd. I was under the impression that QTMHHTTP profile was used to access web pages on the IFS and QTMHHTTP1 was the profile used to execute the CGI programs. Does QTMHHTTP1 have authority to SLS? Justin Houchin Programmer and Web Developer www.reliatek.com email@example.com -----Original Message----- From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of David J. Smith Sent: Wednesday, December 18, 2002 8:21 PM To: firstname.lastname@example.org Subject: [WEB400] CGI and SQL I recently changed one of my CGI programs to use SQL. Based on my change, it quit working! Damn. The program runs fine when I run it with my user ID and test it with debug. When I run it using CGI (User QTMHHTTP), I get the following error: Attempt to use permanent system object QSQRXLTR without authority. Attempt to use permanent system object QSQRLEX without authority. I also get a message saying I'm not authorized to the file I'm doing my SELECT on. Before: QTMHHTTP was authorized to SLS: FSLS IF E K DISK ExtFile(wSLS) F USROPN C EVAL wSLS = 'LIBRARY/SLS' C OPEN SLS After: QTMHHTTP is not authorized to SLS C/Exec SQL C+ SELECT.......FROM LIBRARY.SLS........ Running V5R1. Users have little authority, programs have lots. David Smith President Advanced Information Solutions, Inc. Email: email@example.com Phone: 517.548.7170 _______________________________________________ This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To post a message email: WEB400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/web400 or email: WEB400firstname.lastname@example.org Before posting, please take a moment to review the archives at http://archive.midrange.com/web400.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.