Cannot see the data but can connect

S

Shak

New Member
Hello,
At my job, I,ve been given a task a develop .NET application underlying SQL SERVER database. The data is coming from Progress database which is used by Epicor. I want to filter the data and develop an application but my problem is that as I try to connect to the database through ODBC (DataDirect 4.20 32-Bit Progress SQL92 v10.0B), I can connect and able to see the tables, and their data types but I cannot see any data coming from live database. We also have Pilot database and when I connect to that, I can see the data very well. So, I am confused where is the problem? Any one can help, plz...?
 
Sounds like a grant problem on production database, are you connecting as sysprogress or the owner of the database, if not you or your dba need to, and the grant select privledges to your id or to public. Search for "grant select" in the Progress KB for examples
 
Maybe check the login user on the db is a good idea.
If you manage to use the same that the other application, you should be able to solve the problem.
If you can not then you'll need another user with the grants.
 
You must log in or register to reply here.
Back
Top