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=’‘ />acket writer failure" <br />Has anybody had luck creating parameterized oracle reports with string data type??? <br />Any help appreciated. <br />]]>