Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports .Net and AS400 DB2 Connection Error

Status
Not open for further replies.
NatGreen

NatGreen

Programmer
Apr 19, 2002
90
US
I'm trying to use Crystal Reports & ASP .net to do a simple report using data on an AS400. The report has 3 parameters. I am using the IBM OBBC driver. In the Add Command feature of crystal, when I hard code the values it works, but when I setup parmeters, the query fails and I get the message below.

Failed to open a rowset.
Details: HY000:[IBM][iSeries Access ODBC Driver][DB2 UDB][SQL0302 - Conversion error on input host variable or parameter *N.

I haven't been able to find a resolution yet. Is there a better way to pull data from AS400.DB2 using input parmeters with Crystal?


Thanks in advance!!
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
434
Kennymc
Kennymc
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
313
Ivan Kok
Ivan Kok
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
326
dgillz
dgillz
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
407
hilfy
hilfy
sgoyal11
  • Locked
  • Question
Conditional Link to the table in Crystal Reports 2011
2
Replies
23
Views
716
sgoyal11
sgoyal11

Part and Inventory Search

Sponsor

Back
Top