When using SQL-92 drivers for Progress, you may find that queries using single-element identifiers which worked fine with the SQL-89 drivers, e.g., SELECT * FROM tablename, need the addition of the PUB identifer, e.g., SELECT * FROM PUB.tablename.

This is due to a number of changes in the underlying Progress layers, and can generally be worked around by using our "Initial SQL" option.

Simply create a text file, e.g., openlink.sql, containing the following line --

SET SCHEMA pub;

Pass the full path to this file, including the file extension, in the "Initial SQL" field of your DSN (found on the fourth pane of the Windows Setup Dialog, under the heading "Additional connect parameters". If using a Unix client, the $ODBCINI DSN keyword to hold this value is "initsql".

Once this is done, you should not need to prefix your table names with "pub.", but any queries which already include the prefix should continue to work just fine.