Re: Unable to open the Databases tree in Navigator

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.