Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help Req: ADO Error code : 0x80040e10 Post Reply Post New Topic
Author Message
misahil
Newbie
Newbie


Joined: 26 Sep 2015
Location: Pakistan
Online Status: Offline
Posts: 2
Quote misahil Replybullet Topic: Help Req: ADO Error code : 0x80040e10
    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 ...?  






IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet 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
IP IP Logged
misahil
Newbie
Newbie


Joined: 26 Sep 2015
Location: Pakistan
Online Status: Offline
Posts: 2
Quote misahil Replybullet 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.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.063 seconds.