RE: V5R4 and ODBC

You need the STRHOSTSVR command, or use iSeries Navigator and open Network > Servers > iSeries Access...

Here's a little help...
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii/rzaiiodbc25.htm

To check quickly, just WRKJOB QZDASOINIT and see if there are any active jobs. This is the job that services ODBC requests...

hth,
Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Kern, Mary T
Sent: Friday, July 27, 2007 12:03 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC


I can see the user log in in the history log. So the profile would be fine. Looking in CFGTCP, I don't see a TCP/IP server. Should I be looking somewhere else?


Thanks!
Mary

¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
Mary Kern
Director of Information Services
University of Toledo Foundation
2801 W Bancroft St Mail Stop 319, Toledo, OH 43606
Voice: (419) 530-5611 (800) 640-0147 Fax: 419-530-2895
Email: Mary.kern4@xxxxxxxxxxx
"Three things in human life are important. The first is to be kind.
The second is to be kind. The third is to be kind. -- Henry James
¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«


-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Friday, July 27, 2007 11:08 AM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

Did the host servers start?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Friday, July 27, 2007 9:00 AM
To: Midrange Systems Technical Discussion
Subject: Re: V5R4 and ODBC


Mary,

You've received some good suggestions. Starting with V5R3 and beyond, IBM
got a lot more picky with CCSID and has caused a lot of issues.

Another possibility, however remote, is an expiration of the user profile
associated with that job, etc.

Be nice if IBM had a checklist for ODBC trouble shooting like they did
with email
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzair/rzairfixemail.htm
Anyone seen anything like this in InfoCenter?


Rob Berendt