Using Progress View Through ODBC (No Hyphens)

[pkcitstaff]

Trying to connect through ODBC to a view I created in Progress. The view was created to rename some columns that have hyphens / dashes.

The view is called NODASH and through procedure editor I can query it "SELECT fax_num FROM NODASH" works fine.

But from SQL Explorer or an ODBC connection I get an error on a similar "SELECT fax_num FROM PUB.NODASH"

The error is Table/View/Synonym not found (7519)

Am I querying the view incorrectly?

Thanks for any help.

 

[OpenLink]

Can you issue the "tables" call via ODBC? If so, do you see NODASH qualified with PUB?