Re: Run SQL Scripts fails to start...

Found the following:
Document Number: 387681872

Document Title
Run SQL Scripts Will Not Start in iSeries Navigator

Document Description
If attempting to use the Run SQL Scripts function of IBM® iSeries®
Navigator results in a message box containing only a red X and an OK
button, do the following to correct the problem:

Note: These instructions might correct other error messages that occur
when starting the Run SQL Scripts function.
1 Close iSeries Navigator.
2 Open Microsoft® Windows® Explorer.
3 Navigate to the following path:

C:\Documents and Settings\All Users\Documents\IBM\Client Access\Config
4 Delete or rename the OpNav.Java.User.ser file. This file saves the
settings for the JDBC driver, and it will be re-created the next time
the Run SQL Scripts function is used.

tried this, but it didn't seem to help... (though now that I found it
I remember having it work in the past)

But, the file hasn't been recreated either....thinking it might be
cached, so I'm going to try a reboot...

If that fails will probably contact IBM.

Charles

On Mon, Jun 13, 2011 at 2:44 PM, <rob@xxxxxxxxx> wrote:

I'd call IBM.


Rob Berendt
--
Group Dekko
Dept 1600
Mail to:  2505 Dekko Drive
         Garrett, IN 46738
Ship to:  Dock 108
         6928N 400E
         Kendallville, IN 46755
http://www.dekko.com





From:   Charles Wilt <charles.wilt@xxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   06/13/2011 02:25 PM
Subject:        Run SQL Scripts fails to start...
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



All,

Recently, I started getting a message "Exception - An unknown error
has occurred" when trying to start the Run SQL Scripts component of
iNav.

This was using 7.1 of System i Access for Windows.

Google lead me to a recommendation to uninstall and reinstall...

The uninstall seemed to hang at the end; the program was gone from the
start menu and the Add/Remove programs tool...but I manually deleted
the C:\Program Files\IBM\Client Access folder and clean up some
registry entries.

Trying to reinstall 7.1 (multiple times), the install kept failing
saying that a couple different DLL's failed to register...

I tried installing v5r4 (from our iSeries), but the setup just seemed to
hang...

So I tried installing 6.1.  Finally, the install completed
successfully as did the installation of the latest service pack.

Of course, when I try to start Run SQL Scripts, I get... "Exception -
An unknown error has occurred"  :0  ....what a waste of a morning...

I'm running WinXP Pro with SP 3...

Any thoughts?

Thanks!
Charles
--
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.