Yes, as mention in one of my posts...that what I did.

Though I get some funky error trying to use it.

Charles

On Wed, Apr 27, 2011 at 3:03 PM, Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx> wrote:
Linking to Run SQL scripts does not prompt for a log on at each server
connection (at least for me on iNav 7.1).  I open multiple sessions
quite often.

However, if Charles were to create another connection  to the same box
with a different name then I think it would work.

Thanks, Matt

-----Original Message-----
From: Luis Rodriguez [mailto:luisro58@xxxxxxxxx]
Sent: Wednesday, April 27, 2011 12:16 PM
To: Midrange Systems Technical Discussion
Subject: Re: Can you change the user profile used by iNav's Run SQL
Scripts?

Charles,

Maybe a little cumbersome, but if you create a shortcut to iNav's Run
SQL
Scripts program (in my PC, using iSeries Access V5R4: cwbundbs.exe ), it
will always ask for User ID and Password, even if you already have
iSeries
Access running.

HTH,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--



On Wed, Apr 27, 2011 at 1:30 PM, Charles Wilt
<charles.wilt@xxxxxxxxx>wrote:

Sure...

But I'd have to disconnect the system in iNav, change it to prompt
always, and maybe even close the open 5250 sessions...

Kind of a PITA :)

Which is why I was hoping there was a way to change the user being
used for Run SQL scripts...

Perhaps I'll just use another SQL tool....

Charles

On Wed, Apr 27, 2011 at 1:32 PM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx> wrote:
Can't you simply sign on to iNav with a different userid?

On 4/27/2011 7:25 AM, Charles Wilt wrote:
Is it not possible to change the user profile used by iNav's Run
SQL
Script to connect with a different user profile?
--
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.


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



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



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].