JDBC connection to Progress database

[jgolden]

We have Progress 9.1C database on Solaris 2.6 platform
I managed to successfully start the Progress SQL Explorer which indicates that the jdbc driver for the database is fine. But within SQL Explorer when I try to execute the basic SQL statement ( like select * from table_name) I got an error:
SQLState=42502
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)

Can anybody point me to the right direction.

Many thanks in advance

 

[fmp]

Originally posted by jgolden
We have Progress 9.1C database on Solaris 2.6 platform
I managed to successfully start the Progress SQL Explorer which indicates that the jdbc driver for the database is fine. But within SQL Explorer when I try to execute the basic SQL statement ( like select * from table_name) I got an error:
SQLState=42502
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)

Can anybody point me to the right direction.

Many thanks in advance

Try adding <owner>. to your table_name.
ie... select * from pub.table_name

fmp