Re: Unable to open the Databases tree in Navigator

[PaultinNZ <paultormey@xxxxxxxxx>]

The problem was the exit point. Updated our ODBCUSER table on this system
and voila all okay.

But thanks to all who tried to help.

Cheers
Paul

On 29 June 2010 01:21, <rob@xxxxxxxxx> wrote:

> While I like the idea of the exit point, before I was reminded of that I
> was thinking along the lines of Jim's response.
> Try a WRKRDBDIRE.  Try use STRSQL on another partition and then doing
> CONNECT TO that partition and query a file.
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Jim Oberholtzer <midrangel@xxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   06/27/2010 08:51 AM
> Subject:        Re: Unable to open the Databases tree in Navigator
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Check the relational database names.  Maybe they got whacked somewhere
> along the line.
>
> Also I have noticed when moving from Navigator V5R4 to V6R1 to 7 that it
> did not retain all of the systems/passwords etc. properly, so checking
> to be sure the ODBC settings are correct would be in order.
>
> Jim Oberholtzer
> CEO/Chief Technical Architect
> Agile Technology Architects, LLC
>
>
> On 6/25/2010 7:10 PM, PaultinNZ wrote:
> > *This message was transferred with a trial version of CommuniGate(r)
> Pro*
> > Vern,
> >
> > All systems are the same level and I think Evan has hit the nail on the
> > head.
> >
> > Thanks Evan, I'll have a look at this later this weekend. Gotta go
> shopping
> > right now.
> >
> > Yeah, I did look in the history logs but just saw the connection
> starting
> > and ending with no obvious errors.
> >
> > Will let you know the outcome.
> >
> > Cheers
> > Paul
> >
> > On 26 June 2010 11:54, Evan Harris<auctionitis@xxxxxxxxx>  wrote:
> >
> >
> > > Paul
> > >
> > > This is a long shot, but you guys have an ODBC exit program registered
> on
> > > at
> > > least one of your systems. Access to ODBC is controlled by the user
> being
> > > enrolled in a table on the system somewhere. You might want to make
> sure
> > > your profile is registered in the table that controls access.
> > >
> > > I think it has a name like ODBCADMIN and is probably in the FPGPL
> library
> > > but they are just guesses to get you started. I wish I could remember
> more
> > > but I only looked at it once after I did you V5R4 upgrades
> > >
> > > If you are not getting an error message in Navigator you might try
> looking
> > > the history log and the jobs in subsystem QSYSWRK on the system you
> can't
> > > access to see if there is an error anywhere there that points you in
> the
> > > right direction. (I think that was how I originally located the exit
> > > program)
> > >
> > > Regards
> > > Evan Harris
> > >
> > > On Sat, Jun 26, 2010 at 11:39 AM, Vern Hamberg<vhamberg@xxxxxxxxxxx>
> > > wrote:
> > >
> > >
> > > > Paul
> > > >
> > > > What OS versions are running? Is this one system different?
> > > >
> > > > Vern
> > > >
> > > > On 6/25/2010 4:36 PM, PaultinNZ wrote:
> > > >
> > > > > Hi guys,
> > > > >
> > > > > Have recently upgraded our 4 i's and i Access to V6R1M0 and all went
> > > > pretty
> > > >
> > > > > smoothly.
> > > > >
> > > > > But I have a problem connecting to the Databases tree on 1 system
> only.
> > > > >
> > > > The
> > > >
> > > > > connection doesn't get setup.
> > > > >
> > > > > My question is really - is there anything I have to define on the i5
> > > > system
> > > >
> > > > > to allow this "DATABASES" access. From System i Navigator I can do
> > > > anything
> > > >
> > > > > else to the i5 environment. I just can't access the Databases
> > > > environment.
> > > >
> > > > > Any ideas?
> > > > >
> > > > >
> > > > > Paul Tormey
> > > > --
> > > > 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.
> > >
> > > --
> > > Regards
> > > Evan Harris
> > > http://www.auctionitis.co.nz
> > > --
> > > 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.