Sql Server Reporting Service and Oracle | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql Server Reporting Service and Oracle

I am trying to create a parameterized report using SQL SERVER reporting services connecting to Oracle. <br />It works fine for integer data types but not for string data types. I am using Microsoft OLEDB Provider for Oracle to connect to Oracle. <br />I get the follwing error when I run the query with a string data type parameter <br />"TNS<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />acket writer failure" <br />Has anybody had luck creating parameterized oracle reports with string data type??? <br />Any help appreciated. <br />