HY000 DATADIRECT ODBC OPENEDGE DRIVER

You have to create a SQL user and assign a password. Thread starter qadvietnam Start date Dec 17, In an ABL client you can connect to a Progress database as a blank user and query tables without explicitly being given privilege to do so. Then another user that has sufficient privilege i. Sign up using Email and Password. Hi all, I am using Progress Sign up or log in Sign up using Google.

Uploader: Nisida
Date Added: 12 November 2018
File Size: 49.95 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 5695
Price: Free* [*Free Regsitration Required]

Post as a guest Name. Tom Bascom 8, 2 19 Stack Overflow works best with JavaScript enabled. This site uses cookies to help personalise content, tailor your experience and to keep you logged hy00 if you register. This means they inherit those same privileges on newly-created objects. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website dattadirect subject to these policies.

By continuing to use this site, you are consenting to our use of cookies. Email Required, but never shown.

Error When Load Table Progress Openedge

So if, for example, you are creating a user for Crystal Reports, you don’t want that user to be a DBA. After performing the connection to the database, I get the following error message when executing a query to get data:.

  LG KE590 USB DRIVER

I have accessed OpenEdge Management to guarantee all permissions for my user as shown below, but I still get this error message. I configured the DSN with username and password and to access the database I created and everything connected correctly. Hi all, I am using Progress Depending on your data and your reporting needs, it might be all of the tables or only a subset. ht000

Solved: Error When Load Table Progress Openedge – Microsoft Power BI Community

In datadirectt ABL client you can connect to a Progress database as a blank user and query tables without explicitly being given datarirect to do so. Renan Barbosa 1 The 4gl and SQL engines do not share permissions.

Thread starter qadvietnam Start date Dec 17, Resources Latest reviews Search resources. This guide is for OE9. I have performed all the processes for installing and configuring the Progress OpenEdge version After performing the connection to the database, I get the following error message when executing a query to get data: Sign up using Facebook.

Forums New posts Search forums.

satadirect Read through this KB article for more information: The “renan” user id may not be a SQL user — that also depends on the Progress version how this db has been setup. The permissions that you are showing from “data administration” are 4gl permissions.

  LENOVO V460 WIFI DRIVER

Depending on what version of Progress this is and how this database was setup and created you might also have a “sysprogress” user defined who might be the system DBA user.

This error is telling you that the database user does not have the required privilege to access the table it was trying to read. Members Registered members Current visitors.

If a user is not a DBA their privileges are at the object level and they must be granted privileges individually on each object.

What’s new New posts New resources Latest activity. Then another user that has sufficient privilege i. Actually, I had created the database and only then created a new user and assigned the permissions to this user. If nothing else has been done the initial SQL dba is the user who created the db. You must log in or register datadircet reply here.

Author: admin