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.