Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL error when running a report from e3 software

Posted on 2008-06-20
5
Medium Priority
?
268 Views
Last Modified: 2012-05-05
Screenshot is attached of the full error.  I've opened up permissions on the database and the server.  This is running on SQL Express 2005. The client and the server are running the same versions of the .NET framework.  Any suggestions?
sql-error.jpg
0
Comment
Question by:eServ
5 Comments
 
LVL 21

Assisted Solution

by:Kevin3NF
Kevin3NF earned 664 total points
ID: 21831573
Don't know what e3 software is, but its trying to retrieve data from a column that apparently doesn't exist in the underlying table...see the very first line.

Did this ever work?  What changed?
0
 
LVL 17

Assisted Solution

by:Daniel Reynolds
Daniel Reynolds earned 664 total points
ID: 21831599
Yes, check your code for a reference to ComponentData column. and then check the underlying sql to see if that column is indeed called that or if it needs to be aliased to that.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 672 total points
ID: 21835553
Is this when you run the report?

Have you verified the database?
  Click DATABASE --> VERIFY DATABASE

What version of Crystal?

mlmcc
0
 

Author Comment

by:eServ
ID: 21882697
After talking with E3 support what I am trying to do is only in beta and therefore unsupported.  Thanks agian for all your help
0
 

Author Comment

by:eServ
ID: 21976785
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

926 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