HY000 DATADIRECT ODBC OPENEDGE DRIVER

I have performed all the processes for installing and configuring the Progress OpenEdge version I configured the DSN with username and password and to access the database I created and everything connected correctly. Depending on your data and your reporting needs, it might be all of the tables or only a subset. By continuing to use this site, you are consenting to our use of cookies. These users and their privileges are stored in the systabauth, syscolauth, and sysseqauth tables in the sysprogress schema. Stack Overflow works best with JavaScript enabled.

Uploader: Kazrataur
Date Added: 12 August 2008
File Size: 53.69 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 93831
Price: Free* [*Free Regsitration Required]

You have to create a SQL openedfe and assign a password. These users and their privileges are stored in the sysdbauth table in the sysprogress schema.

logon failed. Details :HY[DataDirect][ODBC Progress OpenEdge Wire Protocol drive

After performing the connection to the database, I get the following error message when executing a query to get data:. This means they inherit those same privileges on newly-created objects. I have performed all the processes for installing and configuring the Progress OpenEdge version What’s new New posts New resources Latest activity. Forums New posts Search forums. By continuing to use this site, you are consenting to our use of cookies.

  INTEL R ICH10 FAMILY PCI EXPRESS DRIVER DOWNLOAD

These users and their privileges are stored in the systabauth, syscolauth, and sysseqauth tables in the sysprogress schema.

Sign up using Email and Password. Members Registered members Current visitors. It is good practice not to grant users more privilege than they require. If a user is not a DBA their privileges are at the object level and they must be granted privileges individually on each object. This error is telling you that the database user does not have the required privilege to access the table it was trying to read.

I have accessed OpenEdge Management to guarantee all permissions for my user as shown below, but I still get this error message. Email Required, but never shown.

Error When Load Table Progress Openedge

Post as a guest Name. After performing the connection to the database, I get the following error message when executing a query to get data: This guide is for OE9.

In a SQL client, you can’t. If nothing else has been done the initial SQL dba is the user who created the db. For a better experience, please enable JavaScript in your browser before proceeding. Then another user that has sufficient privilege i.

Thread starter qadvietnam Start date Dec 17, Renan Barbosa 1 The 4gl and SQL oebc do not share permissions. Stack Overflow works best with JavaScript enabled. 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.

  MSI MS-AC71 DRIVER

Sign up using Facebook. Depending on your data and your reporting needs, it might be all of the tables or only a subset.

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 is subject to these policies. So should I create a new database with the user ‘renan’ so I can access and perform the operations?

If a user is a DBA datadirsct have all privileges on all objects, at the database level. Tom Bascom 8, 2 19 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.