Solved

Connecting Crystal Reports to Lawson via Query Builder for Lawson

Posted on 2003-11-07
6
1,467 Views
1 Endorsement
Last Modified: 2012-06-21
Background of the situation:
Our company is trying to use Crystal Reports for creating reports using data from Lawson. We are using the Enterprise Reporting add-on for Crystal Reports that provides connectivity to the Lawson Information Object Service. This enterprise reporting piece installs OLE DB connectivity to Lawson. We are then trying to use Query Builder to connect to Lawson using this OLE DB connection.

Overview of the problem:
When we try to connect to Lawson via the Query builder we are getting the following error from Crystal reports after specifying the web server, the default product line and the user and password:

>>>
Logon failed.
Details: ADO Error Code: 0x80040e4d
Source: Data Source
Description: No Data Area has been specified

|5|-2147217843|80040e4d|Data Source|IDBInitialize.cpp|107|-1|-1|-1||
Native Error: 5
>>>

Depending on the choice of user we get a slightly different error:
>>>
Logon failed.
Details: ADO Error Code: 0x80004005
Description: IOS command returned no data

|153|-2147467259|80004005||LoganDvr.cpp|680|-1|-1|-1||
Native Error: 153
>>>

Additional environment information:
The version for Crystal Reports is 9.0 and the Lawson version is 7.3.3.0 with installed IOS service. We have also updated the crdb_ado.dll file to the latest available version.

All suggestions will be greatly appreciated !
1
Comment
Question by:contemporarystaffing
  • 2
  • 2
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
Comment Utility
0
 
LVL 7

Assisted Solution

by:mnye
mnye earned 250 total points
Comment Utility
contemporarystaffing,

interesting to find someone else using the Lawson Query Builder.  I just started using it with crystal myself. I havent seen the error you're running into, but im on Lawson version 8.0.3.  What version of Query Builder are you using?

Dont suppose you have any experience publishing reports based off the Query Builder via ASP.Net? im having some issues myself that im trying to work through.

good luck,
Matt
0
 
LVL 7

Expert Comment

by:mnye
Comment Utility
actually looking at those error messages that looks like you just arent returning any data.  have tried selected any other data area other than default? If not are the system codes being populated? have you talked with you Lawson System Admin? perhaps they never set up a default data area.

hth
matt
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

762 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

8 Experts available now in Live!

Get 1:1 Help Now