Print Page | Close Window

Help Req: ADO Error code : 0x80040e10

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21712
Printed Date: 02 May 2024 at 10:40pm


Topic: Help Req: ADO Error code : 0x80040e10
Posted By: misahil
Subject: Help Req: ADO Error code : 0x80040e10
Date Posted: 02 Oct 2015 at 6:11am
I trying to create a Crystal Report with Oracle 11g Database using OLE DB ADO (Microsoft OLE DB Provider for Oracle ) I add the following SQL Command  in add command


SELECT 0 AS VoucherNo, To_Date(?TxtFromDt) as VoucherDate, Vendors.VendorName, 'Balance Brought Forward' AS Narration,
Null as DocumentNo, 0 AS Debit, 0 AS Credit, Sum(DR-CR) AS Balance
FROM Vouchers A INNER JOIN Vendors ON A.ClientID = Vendors.VendorID
WHERE ( ((A.VoucherDate)< ?TxtFromDt) AND (A.ClientID = ?MyClientID) AND VStatus='Y' )
GROUP BY  Vendors.VendorName, 'Balance Brought Forward'
UNION SELECT A.VoucherNo, A.VoucherDate, Vendors.VendorName, A.Narration,A.DocumentNo, A.DR AS Debit, A.CR AS Credit,
(Select  Sum(DR-CR) FROM Vouchers Where Vouchers.ClientID=A.ClientID and VoucherNo<= A.VoucherNo AND  VStatus='Y' ) AS Balance
FROM Vouchers A INNER JOIN Vendors ON A.ClientID = Vendors.VendorID
WHERE (((A.VoucherDate) Between ?TxtFromDt And ?TxtToDt) AND ((A.ClientID)= ?MyClientID) AND VStatus='Y' )
GROUP BY A.VoucherNo, A.VoucherDate, A.ClientID, Vendors.VendorName, A.Narration,A.DocumentNo, A.DR, A.CR

But it give the FOLLOWING Error: ADO Error code : 0x80040e10
No Value given for one or more required parameters.

Can any body help ...?  








Replies:
Posted By: praveeng
Date Posted: 04 Oct 2015 at 10:39pm
Hi,

For OLE DB use:

MS SQL 2005 - OLE DB Provider
MS SQL 2008 - SQL Native 10
MS SQL 2012 - SQL Native 11
MS SQL 2013 - SQL Native 11

Also, what version of SQL Server are you connecting to??
When you run this manually, are you logged in with the same credentials as the report uses?
Have you tried connecting via a different driver? If you've installed Oracle Client drivers, could you try the Native way?

The error is as it indicates. What ever account you are logged into as and running CR 2011 under does not have permissions to alter what is defined in the SP. Are you using Trusted Authentication?

--Praveen G

-------------
Praveen Guntuka,
praveen_guntuka@yahoo.com

Posted By: misahil
Date Posted: 04 Oct 2015 at 11:13pm
Originally posted by praveeng

Hi,

For OLE DB use:

MS SQL 2005 - OLE DB Provider
MS SQL 2008 - SQL Native 10
MS SQL 2012 - SQL Native 11
MS SQL 2013 - SQL Native 11

Also, what version of SQL Server are you connecting to??
When you run this manually, are you logged in with the same credentials as the report uses?
Have you tried connecting via a different driver? If you've installed Oracle Client drivers, could you try the Native way?

The error is as it indicates. What ever account you are logged into as and running CR 2011 under does not have permissions to alter what is defined in the SP. Are you using Trusted Authentication?

--Praveen G



Thank u very much Praveen G for ur reply.

pls. find below the answers of ur questions  u have asked for my help.

As I mentioned that i am using Oracle 11g Database and not MS SQL .... .
Yes I installed Oracle Client drivers,
When i run the above-mentioned statement in SQL* Plus it works fine  and display the correct results.
I am using CR 2009 and not CR2011.

waiting for ur helpfull reply.


Print Page | Close Window