Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

failed to retrieve data from the database

Posted on 2014-04-22
10
Medium Priority
?
229 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 9

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 9

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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

715 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