Error trying to insert database for use in a merge

[jeff]

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

 

[Peter Jamieson]

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).