Home > Odbc Error > Odbc Error 7512

Odbc Error 7512

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. However, they can query the sysprogress.sysdbauth table to determine who the original default DBA was:  SQLExplorer>select * from sysprogress.sysdbauth;  GRANTEE                       From there you need to go on and create users on the SQL engine and grant them the necessary priviliges. http://brecnc.org/odbc-error/odbc-error-oracle-odbc-numeric-value-out-of-range.html

Ignore the SYSPROGRESS user as this is an internal account and should not be generally used3. If you google :"openedge sql authorization explained" you will find a word document I used find out how to do it. ALso tried in between quotes and without them, I succeed connecting to all the SYSPROGRESS tables but to none of the PUB. Register now while it's still free!

Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for RealHeavyDude, Feb 13, 2012 #4 (You must log in or sign up to reply here.) Show Ignored Content Share This Page Tweet Log in with Facebook Your name or email address: One table with 500 columns vs 1000 individual Tables. 5 33 3d Entity Framework and Store Procedures that return multiple resultsets Article by: Alexandre Entity Framework is a powerful tool to Characters Remaining: 255 Copyright © 2016, Progress Software Corporation and/or its subsidiaries or affiliates.

But I like this solution better as it makes for better programming. Learn More. You’ll be auto redirected in 1 second. That means that you need to set up the SQL security no matter how the security on the 4GL engine is set up.

I'm trying to connect from a MSAccess 2007 front-end using DataDirect Progress ODBC to a Progress 10.1a database. and/or other countries. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Doesn't seem a privilege problem to me because we succeed to connect to the PUB.

Regards Bogdan Reply With Quote 01-23-09,07:47 #3 jpsilenzi View Profile View Forum Posts Registered User Join Date Jan 2009 Posts 3 Question:Progress ODBC Driver problem Originally Posted by brbogdan Hi, Try However I still have a problem. Results 1 to 3 of 3 Thread: Progress ODBC Driver problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Registration on or use of this site constitutes acceptance of our Privacy Policy.

This step can't be performed from the SQL client because none of the existing users have SQL DBA rights.4. Thursday, April 24, 2008 4:15 PM 0 Sign in to vote We are changing the issue type to “Comment” because you have not followed up with the necessary information. If you receive the similar error that means you have no rights to view data in location table. I would be glad if you could help me and elaborate the solution.

Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! http://brecnc.org/odbc-error/odbc-error-523-80.html Join UsClose Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Thank you!

Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for OpenEdge-SQL-Authorization-Expla.doc 0 LVL 4 Overall: Level 4 Databases 4 MS SQL Server 2005 1 Message Accepted Solution by:progressor2010-01-05 Use this Progress 4GL code to generate the script: This generates scripts Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. http://brecnc.org/odbc-error/odbc-error-merant-odbc-sqlbase-driver.html Monday, April 28, 2008 7:30 AM Moderator 0 Sign in to vote I had this issue and when setting up database link in access I selected save password, all OK now

The DSN uses datadirect drivers. Your feedback is appreciated. Get 1:1 Help Now Advertise Here Enjoyed your answer?

Regards Bogdan Hi brbogdan What if the error states a mis-spelling of the table name (even knowing it's spelled correctly).

Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Identify the name for the user who created the db and use the OpenEdge Data Administration tool to add this user and assign a password. ResolutionEnsure the correct userid/password is entered (Type the password in plain text as test to see if the characters are the expected ones)If the userid has a blank password, recreate this It's like the users don't have permission to use the Openedge odbc driver.

My AccountSearchMapsYouTubePlayGmailDriveCalendarGoogle+TranslatePhotosMoreDocsBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers We then close the database and re-open it and it then produces an error Access Denied - Authorisation Failed (7512) (#-20228).The even stranger thing is we can view the table design Launch report from a menu, considering criteria only when it is filled… MS Office Office 365 Databases MS Access Advertise Here 759 members asked questions and received personalized solutions in the weblink Featured Post PRTG Network Monitor: Intuitive Network Monitoring Promoted by Paessler GmbH Network Monitoring is essential to ensure that computer systems and network devices are running.

Please tell us how we can make this article more useful.