"cannot obtain a list of databases" when connecting to ODBC datasource

L

Lorraine Ford

We have recently encountered this problem after upgrading to Word 2003.
When we try to create a mail merge document, and bring up the window where you
can see the list of your ODBC datasources, we can no longer access some of the
datasources. Let me clarify, The ODBC 'administrator' screen does bring up the
connection screen, and I can click "test connection' and the connection to the
database is successful, but when I click OK to return to MS Word, this error
appears on the screen in a message box with the title" Microsoft Office Word":
"The Data Connection Wizard cannot obtain a list of databases from the specified
data source."

The ODBC datasources that fail are both Sybase Adaptive Server Anywhere version
5.5 and version 9 connections.

If we select the Microsoft Access sample databasenorthwind.mdb, the connection
and table list comes up fine.

These connections worked with no problem in the previous version of MS Word.

This test has been repeated on more than one machine, but both were using
Windows XP service pack 1.

Also, we do have the 'Update Links on Opening' option set.

Thanks.
Lorraine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top