Solved

failed to retrieve data from the database

Posted on 2014-04-22
10
206 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
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 18

Expert Comment

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

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

828 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