With Excel the ODBC drivers of Iseries access (old client access/400 or new
iseries access) works well and return me data correctly. In Word the
connection ask me for a password and i can choose the library/file. Then
appears a windows with all types of converters and odbc, but the iseries
access odbc doesn't appear and i must choose "Database file OLE DB", i know
the other types (mdb, xls, qy etc..). At this time appears "unable to open
data source" (unable - impossible in english version ??). Finish...

"Peter Jamieson" wrote:

My guess is that this is a security (login/password) issue. When you connect
from Word to the ISERIES, do you use MS Query? Do you have to enter a
login/password? If so, the problem is probably that MS Word "forgets" the
username and paassword later. If so, suggestions:
a. can you specify the username and password in the ODBC DSN for the
Iseries? If you cannot do it in a "user" or "system" DSN, try creating a
file DSN and adding the necessary parameters manually. Then try using that
..dsn when you start MS Query
b. use Word VBA and an OpenDataSource call to specify the necessary ODBC
connection information. This is not straightforward so you may need further
help. Unfortunately, I do not have an ISERIES here so cannot tell you
exactly what should be in the connection string.

Also, in both cases, you will be storing login/password information in a
rather insecure way, so be careful!

Peter Jamieson

"Renzo_F" wrote in message
...
when i try to merge directly from Iseries as400 file in a word document I
receive the message: Record 1 contains too few data...etc. I use a ISERIES
ACCESS ODBC DRIVER (ver.10.00.03.00) OS400 ver. 5.3.0 Iseries Access
ver.5.3.0 on windows XP pro and Office 2002 SP3 (all fixes of windows and
office are installed). The same links works correctly between Iseries
as400
and excel of the same office. Please help me...
Bye.
Renzo.