Re: MS Word/Query AS400 database error

["Jim Franz" <franz400@xxxxxxxxxxxx>]

Chris,
Both docs use the same data source (i have only one source identified).
>From the "working" doc and the "non-working" doc - same source, and
files are in same lib. I can preview the data from MS Query, so I know
the dsn is working, but when I click Return to MS Word, I get the
error. Only difference I can see is the file.
As a test I just created a new doc, with new file. No problem.
Is there a size limit? The failing doc is getting 30-40 fields instead of
10-15.
jim
----- Original Message -----
From: "Chris Devous" <cdevous@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, May 23, 2003 10:34 AM
Subject: Re: MS Word/Query AS400 database error


> Jim,
>
> Are both documents using the same data source, or did you create a new
data
> source for the new document? If so, look to the new data source,
particularly to the
> library list.  Make sure you don't have both the default library and a
library list
> specified.
>
> I'm shooting in the dark here, but it sounds like the issue is with the
DSN, and not
> word or ODBC, per se.
>
> --Chris
>
>
> On 23 May 2003 at 8:55, Jim Franz wrote:
>
> > On an older system, V4R5, I have an CA ODBC connection to the 400.
> > Client Access is on a Terminal Server 2000, and using Word 2000.
> > Created the first Word doc, pulling in a customer file to create mass
> > mailing. Worked great. Had to create a new AS400 file, merging data
> > from multiple files. Created a new Word doc, do the MS Query,  and can
> > even preview the data. But on the final button to bring it back to
> > Word, I get the truly generic message "Word was unable to open the
> > data source". Is there some logging or details somewhere? MS Query
> > seems to be working, but not inside the Word doc. Have created a new
> > doc, and have same problems, so I'm wondering about my new file.
> > Normal DDS specs, largest field is 60A, total record length 900 bytes,
> > about 40 fields, all alpha, no more than 8 char field names, 8 char
> > format name. 1st word doc with original file still works fine. tia jim
> > franz
> >
>
>
> _______________________________________________
> 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.
>
>