?
Solved

Connecting Crystal Reports to Lawson via Query Builder for Lawson

Posted on 2003-11-07
6
Medium Priority
?
1,544 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
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 9704312
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 9704317
0
 
LVL 7

Assisted Solution

by:mnye
mnye earned 1000 total points
ID: 9743343
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
ID: 9743517
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

621 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