Querying Progress Tables

S

Strider

New Member
Hello once again.

So i finally got my DSN ODBC connection to Progress Working.

So i've created a vb.net application in which im connecting to the progress database.

Now im trying to query the tables in Progress with SQL

In the Progress Data Dictionary i can see the tables in the database and there is one called customers

so my SQL query is "SELECT * FROM customers"

however when i execute the query i get the following error

"ERROR [42S02] [MERANT][ODBC PROGRESS driver][PROGRESS]Table/View/Synonym not found (7519)"

even though the table exists!!!

Am i missing something from the query?
 
Ah ok....

Can can i call Progress stored procedures in the same way?

When calling access queries over ODBC the structure of the query is "SELECT * FROM <theStoredQueryName>"
 
I've nerver worked with stored procedures, but to call a stored procedure the syntax is: Call <storedprocedurename>()

Casper.
 
Cool, and one last question for today....

One of the databases i have, a sample that comes with progress, i can query fine.

But the one i got of a client when i try to execute a query, whether from my vb.net application or SQL Explorer Tool i get Access denied/Authorisation required error.

How can i modify the database security so i can query it?
 
You have to login to your database as the user who created the database or you have to log in as the default sql dba: sysprogress.

See KB: 20143

With a user with dba permissions you can grant select to user who use odbc only to query the database.

See KB: 21021

HTH,

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