JDBC connection to Progress database

J

jgolden

New Member
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
 
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
Click to expand...



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

fmp
 
You must log in or register to reply here.
Back
Top