Solved

failed to retrieve data from the database

Posted on 2014-04-22
10
194 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 7

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 7

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
 
LVL 18

Expert Comment

by:vasto
ID: 40015479
Do you have any limitations on progress side about the number of active connections ?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now