Friday, March 9, 2012

Reporting service error

i use VS 2005 to develop.

And my DB is oracle

i use the SQL 2005 report service to crate the report .When i deploy to one server is ok .but when i deploy to another server (the server has install the sql 2005 & Oracle client is 10.1.0). when i try to view the report in this server : there will have some error message


An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CmtDataSoucre'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Hope some one can help.

Thanks

Lizzy

I have fixed the issue , by give give the permission to the folder of bin and admin .

But now new issue appear:

the issue is below :

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CmtDataSoucre'. (rsErrorOpeningConnection)
OCIEnvCreate failed with return code -1 but error message text was not available.

Hope some one can help.

Thanks

No comments:

Post a Comment