RE: AS/400 ODBC connection - "Error on assignment" after OS/400 upgrade

Thanks.  I will pass this along to our operations group.

Rick

 -----Original Message-----
From:   John Taylor [mailto:lists@studioworks-tech.com]
Sent:   Tuesday, November 12, 2002 4:49 PM
To:     midrange-l@midrange.com
Subject:        Re: AS/400 ODBC connection - "Error on assignment" after
OS/400 upgrade

Rick,

We had similar troubles after upgrading to V5R2 from V4R5. It turned out
that the database host server job was not being initialized properly.

PTF's MF29383, MF29516, MF29370, and MF29320 were applied to correct the
problems. Be sure to check the special instructions in the cover letter of
MF28370 - you can't just apply it *IMMED.

Regards,

John Taylor

> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of Chevalier, Rick
> Sent: Monday, November 11, 2002 2:54 PM
> To: 'midrange-l@midrange.com'
> Subject: AS/400 ODBC connection - "Error on assignment" after OS/400
> upgrade
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> --
> [ Picked text/plain from multipart/alternative ]
> I have a Word mail merge document containing VBA code to retrieve customer
> information from the AS/400 and create mailing labels.  The document and
> associated ODBC DSN were created with the AS/400 at V5R1.
>
> Things were working well until the system was updated to V5R2.  Now,
> whenever I open the document using Word I receive an error that Word
cannot
> find the data source for the document.  I attempt to recreate the data
> source using MSQuery and it fails with "Error on assignment".  Clicking on
> ok displays another message box with "Unable to open file".  This result
is
> the same when creating a new mail merge document and attempting to create
a
> new data source for the AS/400 with MSQuery.
>
> We have another AS/400 that was as V5R1 at this time.  I could
successfully
> connect to this system either opening an existing document or creating a
new
> mail merge document.  This system has been upgraded to V5R2 recently and
now
> exhibits the same symptoms.  Using Excel or Access to retrieve AS/400 data
> works fine.  The only issues are with MSQuery.
>
> According to our system administrator I have the most recent version of
> Client Access and the latest V5R2 PTF's have been applied.  I have also
> applied the latest updates for Office from Microsoft.
>
> Tracing the ODBC connection shows everything proceeding OK until the error
> on assignment is reached.  This makes me think the issue is with the ODBC
> driver but I can't convince the system administrator.
>
> Where should I look to better identify the source of the error?
>
> Rick Chevalier
> Sr. Programmer Analyst
>
> (817) 525-7178
> rick.chevalier@americredit.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.