Kbase P123994: ODBC error -7747 when linking table with default index in Microsoft Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/08/2009 |
|
Status: Verified
SYMPTOM(s):
ODBC error -7747 when linking to tables in an OpenEdge 10.1x database via MS Access
Error -7747 is generated when confirming the link
Reserved error (-7747); there is no message for this error.
Connection is established via ODBC
Tried adding registry setting "Workarounds=8192" but this had no effect (see P116845)
FACT(s) (Environment):
OpenEdge tables with manually defined indexes are linked as expected
Problem does not occur when using 10.0B ODBC driver; prompts for field to be used as an index
OpenEdge 10.1x
Progress OpenEdge 10.1A driver
Progress OpenEdge 10.1B driver
Progress OpenEdge 10.1C driver
Windows
MS Access 2002 (XP)
MS Access 2003
MS Access 2007
CAUSE:
Bug# OE00151163
CAUSE:
OpenEdge table does not have a manually defined index, only has the default index
FIX:
As a workaround, add an index using Data Dictionary to the table in the Progress database that needs to be linked to in MS Access.
To validate if the table in question has only a default index, use the Data Dictionary and go to Tools>reports>detailed table reports. The
Index Summary section of this report will show the types of indexes that are defined. If no Development license is on the system use prowin32 with the -rx
parameter to get into the Data Dictionary. For example:
prowin32 db-name -H <host-name> -S <port number> -rx