• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

failed to retrieve data from the database

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
BillRozema
Asked:
BillRozema
1 Solution
 
Lee IngallsDirector of IT/TS, Quality and FinanceCommented:
How are you connecting... using the Progress ODBC?
Is the password saved/stored with the data source connection?
0
 
BillRozemaAuthor Commented:
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
 
Lee IngallsDirector of IT/TS, Quality and FinanceCommented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
vastoCommented:
Do you have any limitations on progress side about the number of active connections ?
0
 
mlmccCommented:
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
 
BillRozemaAuthor Commented:
I accessed it thru the administrative tools and the odbc Data Source 32bit.

There is nothing in the windows Syswow64 folder
0
 
BillRozemaAuthor Commented:
selection is in administrative tools as a 32bit option.
0
 
BillRozemaAuthor Commented:
I solved the problem by using the administrator as the user in both squexp and source data  for the databases.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now