Re: Calling a stored procedure from a VB6 program using the DB2 database driver

A while back I had a similar problem.

We used a connection string with a user profile that was given very basic authority. Digging in we found that we needed normal authorities to run jobs through the DB2 interface. You will also need to check the user profile being used is authorized appropriately to the library and other objects like jobs, jobs, etc...

Darryl

Sent from my iPad

On Jul 30, 2015, at 8:46 AM, Mark Walter <mwalter@xxxxxxxxxxxxxxx> wrote:

Hello all,

I have a stored procedure on an iSeries that I created. I'm trying to fire that SP from a VB6 program (Don't ask), using the Microsoft OLE DB Provider for DB2. When I log into the application using my user id, I'm getting an error that I don't have authority to "something". The message is not very clear as to what I don't have access. I know I have authority to the program behind the procedure. I'm the owner and it has *public *all. I'm thinking it's one of the underlying programs or files that tells the iSeries how to convert a SP to a program, for lack of a better explanation.

I can find the QRWTSRVR job that is servicing the request. When the admin gives me *allobj authority (I'm a consultant here), the procedure works fine and I can see the results of the job in the joblog of the QRWTSRVR job. But, that joblog gives me no clue as to what I don't have access.

Any ideas on how I can lock this down?

Thanks,

Mark Walter

Business to Business Data Integration Specialist
Certified IBM System i Specialist
Paragon Consulting Services, Inc.
mwalter@xxxxxxxxxxxxxxx<mailto:mwalter@xxxxxxxxxxxxxxx>
717-764-7909 ext. 20

--
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.