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

x
?
Solved

Connecting Crystal Reports to Lawson via Query Builder for Lawson

Posted on 2003-11-07
6
Medium Priority
?
1,521 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
[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
  • 2
  • 2
6 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

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. …
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

670 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