RE: V5R4 and ODBC

Mary,

Can you access the table in question through any other PC client application (Client Access file transfer, Excel, Crystal Reports, etc.)? If you can have you rebooted the PC?

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


QZADSOINIT is running. We have been at CCSID 37 for several years. And I IPL'd this morning. All Client Access Host severs are running and set to start when TCP starts. Any more ideas?


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: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ketzes, Larry
Sent: Friday, July 27, 2007 3:07 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

Not sure if this helps anyone, but IBM told us that after making the change of system value CCSID from 66535 to 37, we needed to take the system to a restricted state and then back up again. We will be doing this over the weekend.

Larry

Larry Ketzes | Senior iSeries System Administrator | AIG / ALICO - American Life Insurance Company One ALICO Plaza, 600 N. King Street, AMIS | Wilmington, DE 19801 | *: 302.594.2146 | 7: 302.830.4524| *: larry.ketzes@xxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: Friday, July 27, 2007 3:02 PM
To: Midrange Systems Technical Discussion
Subject: 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/rzairfixem
ail.htm
Anyone seen anything like this in InfoCenter?


Rob Berendt