|
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 justin@reliatek.com -----Original Message----- From: web400-admin@midrange.com [mailto:web400-admin@midrange.com] On Behalf Of David J. Smith Sent: Wednesday, December 18, 2002 8:21 PM To: web400@midrange.com 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: dsmith@ais400.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: WEB400-request@midrange.com 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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.