Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Informix error "Failed to retrieve data" Post Reply Post New Topic
Author Message
DufresneM
Newbie
Newbie


Joined: 05 Feb 2011
Location: Canada
Online Status: Offline
Posts: 1
Quote DufresneM Replybullet Topic: Informix error "Failed to retrieve data"
    Posted: 19 Feb 2011 at 11:36am
We just introduced an Avaya system which uses Informix ODBC. We can get a connection to the database tables, however I receive the following error;

Failed to Retrieve Data from the database.
Details: 42000:[Informix][Informix ODBC Driver][Informix]No Select permission. sqlerm(splits) [Database Vendor Code: -272].

We had this error originally. Our Telco vendor fixed the problem. Now, its happening all over again.

Any ideas as to why this is happening?


IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 03 Mar 2011 at 3:52am
This is an access rights issue in the database - the user ID that you're using to log in to the database from the report doesn't have access rights to select data from one or more tables in your report.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.