Solved

failed to retrieve data from the database

Posted on 2014-04-22
10
219 Views
Last Modified: 2014-11-27
Get error message failed to retrieve data from the database in crystal reports (11.5).
The data is progress 11.3 on a windows 2012 server.  Data source has been setup and tested.  Both Crystal and progress are the 32 bit version while the server is 64 bit.

The message starts out as List of values failure: fail to get values.  Failed to retrieve data from the database (-20228)
0
Comment
Question by:BillRozema
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 8

Expert Comment

by:Lee Ingalls
ID: 40015259
How are you connecting... using the Progress ODBC?
Is the password saved/stored with the data source connection?
0
 

Author Comment

by:BillRozema
ID: 40015320
the data source doesn't have a password.
Using the progress ODBC for 11.3 - Progress told me to use it.  Data Direct isn't there as an option
0
 
LVL 8

Expert Comment

by:Lee Ingalls
ID: 40015367
Progress documentation...
http://documentation.progress.com/output/OpenEdge113/pdfs/dmsrf/dmsrf.pdf
Refer to page 214
"20228 28817 Invalid auth specs Access denied (Authorization failed)."
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 18

Expert Comment

by:vasto
ID: 40015479
Do you have any limitations on progress side about the number of active connections ?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40015643
How did you create the ODBC connection?
The 32-bit ODBC application is in Windows/SysWOW64.  If you run through th start menu or control panel that is the 64-bit version

mlmcc
0
 

Author Comment

by:BillRozema
ID: 40017563
I accessed it thru the administrative tools and the odbc Data Source 32bit.

There is nothing in the windows Syswow64 folder
0
 

Author Comment

by:BillRozema
ID: 40017579
selection is in administrative tools as a 32bit option.
0
 

Accepted Solution

by:
BillRozema earned 0 total points
ID: 40029814
I solved the problem by using the administrator as the user in both squexp and source data  for the databases.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question