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)
BillRozemaAsked:
Who is Participating?
 
BillRozemaConnect With a Mentor Author Commented:
I solved the problem by using the administrator as the user in both squexp and source data  for the databases.
0
 
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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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
 
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
All Courses

From novice to tech pro — start learning today.