Unanswered: ODBC link to a Progress 10.1a database fails to retrieve data.
We are developing a solution that has to work with MSAccess 2007 or Visual Studio 2008 as front-end and a Progress 10.1a database. We succeed to connect to all the SYSPROGRESS tables and retrieve its data.
The same doesn't work with the PUB. tables. Everytime we try to retrieve data from them we recieve a message stating that we mis-spelled the table name.
Does anyone know what is happening, help please!
I used the fallowing workaround from the Progress knowledge base:
To resolve this error, set WorkArounds2=8192 for the affected data source. This can be done by using the Registry Editor (RegEdit).
1. Run RegEdit
2. Locate the ODBC DSN in the Registry:
For a USER Data Source, go to HKEY_CURRENT_USER -> Software -> ODBC -> ODBC.INI -> YourDataSourceName
For a SYSTEM Data Source, go to HKEY_LOCAL_MACHINE -> Software -> ODBC -> ODBC.INI -> YourDataSourceName
3. Click on the folder for your data source; from the menu choose:
Edit -> New -> String Value
4. Set the name of the new string value to be WorkArounds2
5. Double click on WorkArounds2 in the right hand panel; this will bring up a dialog box with a data value field