Hi,
I have a problem and am searching for advice/tips. This is our first attempt at accessing the data in a Progress database, and we are having difficulty. The database is in production at a client site. The vendor of the app that uses the Progress db is unwilling to provide assistance (to us or anyone else), although the data belongs to the client, not the vendor.
I have the credentials, names, ports, etc needed to run Progress tools such as SQL Explorer, Data Dictionary, etc. Using SQL Explorer, I can run queries against system tables such as:
select * from sysprogress.systables
Using SQL Explorer, if I try to query a table that the application uses, such as:
select AccountID from Account
I get an "access denied" error. I apologize, it was 2 days ago that I was onsite, and I did not capture the exact error number and verbage. I believe it included "authorization failed".
I know that the table "Account" exists and contains a column named "AccountID"; I discovered this in the Data Dictionary.
I have tried altering the query to include an owner, such as:
select AccountID from pub.Account
select AccountID from PUB.Account
and other guesses.
I have a few ideas about what the problem may be, and am hoping for some guidance.
1) the table that the client application uses are restricted and only accessible through a higher authority user than the credentials I have. My user is *not* listed if I execute:
select * from sysprogress.sysdbauth
(note that my user *can* execute the above query)
2) the tables are only accessible through views/procedures, not direct queries
3) I am missing a schema that will give visibility to the tables
My goals are, first, to query the application's tables using SQL Explorer, and then, to query from a Windows application using ADO.
I apologize if this is a common post, I've searched many newsgroups, and threads on this site, but have not come up with a solution.
Thanks very much in advance.
I have a problem and am searching for advice/tips. This is our first attempt at accessing the data in a Progress database, and we are having difficulty. The database is in production at a client site. The vendor of the app that uses the Progress db is unwilling to provide assistance (to us or anyone else), although the data belongs to the client, not the vendor.
I have the credentials, names, ports, etc needed to run Progress tools such as SQL Explorer, Data Dictionary, etc. Using SQL Explorer, I can run queries against system tables such as:
select * from sysprogress.systables
Using SQL Explorer, if I try to query a table that the application uses, such as:
select AccountID from Account
I get an "access denied" error. I apologize, it was 2 days ago that I was onsite, and I did not capture the exact error number and verbage. I believe it included "authorization failed".
I know that the table "Account" exists and contains a column named "AccountID"; I discovered this in the Data Dictionary.
I have tried altering the query to include an owner, such as:
select AccountID from pub.Account
select AccountID from PUB.Account
and other guesses.
I have a few ideas about what the problem may be, and am hoping for some guidance.
1) the table that the client application uses are restricted and only accessible through a higher authority user than the credentials I have. My user is *not* listed if I execute:
select * from sysprogress.sysdbauth
(note that my user *can* execute the above query)
2) the tables are only accessible through views/procedures, not direct queries
3) I am missing a schema that will give visibility to the tables
My goals are, first, to query the application's tables using SQL Explorer, and then, to query from a Windows application using ADO.
I apologize if this is a common post, I've searched many newsgroups, and threads on this site, but have not come up with a solution.
Thanks very much in advance.