Error trying to insert database for use in a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeff - 26 Apr 2004 20:07 GMT

Trying to setup a WORD merge using data from an Informix
Database. I have successfully set up the ODBC drivers and
was able to successfully setup and execute a M.S. Access
passthru query to read a table from an Informix database.

When trying to perform the same setup in Word to insert a
database and select the table I want to use, using the
data connection wizard I'm able to set up the connection
and have it display all the tables in my datbase. When I
select a table I wish to query and click on the "FINISH"
button, I get the error:

WORD can't open +connect to new data source as a data or
headers source becuase it contains no data. I'm trying to
connect to the same database/table that I am able to do in
Access?

Any thought on what I might be missing?
Thanks

Reply to this Message

Peter Jamieson - 27 Apr 2004 12:48 GMT

There are typically two problems in this area:
a. the ODBC connection string exceeds a 255-character limit
b. login/password information is required to get the data. Even if you have
specified the necessary security info (login/password) for your Informix
database when you set up the connection, Word may not retain it. I don't
have Informix here so cannot test the specifics on this one, but with SQL
Server I have generally had to do one of the following:
- create a file .dsn and put the login/password info in there
- use VBA and OpenDataSource to specify the login/password in the
connection string (if it's a mailmerge source)
- put the security info in the connection string (if it's a DATABASE
field).

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Trying to setup a WORD merge using data from an Informix
> Database. I have successfully set up the ODBC drivers and
[quoted text clipped - 15 lines]
> Any thought on what I might be missing?
> Thanks

Reply to this Message