If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > ODBC link to a Progress 10.1a database fails to retrieve data.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-23-09, 08:11
jpsilenzi jpsilenzi is offline
Registered User
 
Join Date: Jan 2009
Posts: 3
Red face ODBC link to a Progress 10.1a database fails to retrieve data.

Hi
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!
Reply With Quote
  #2 (permalink)  
Old 02-17-09, 06:46
bcwahl bcwahl is offline
Registered User
 
Join Date: Feb 2009
Posts: 1
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

6. Change the data value to 8192

7. Click OK

8. Close RegEdit
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On