WebRequest.RegisterPrefix("http://", WebRequestCreator.ClientHttp);
WebRequest.RegisterPrefix("https://", WebRequestCreator.ClientHttp); I prepared sample project to reproduce the issue, but cannot attach it here Please answer me ASAP if you have some workaround. My project really needs above mentioned code Regards, Michael
Hello,
We are using Telerik Reporting Q2 2010 (winForms). Usually, our report datasources are pointing to SQL Server stored procedures (i.e., property window shows
datasource SelectCommand property set to a stored procedure, SelectCommandType StoredProcedure) that take parameters, and that approach has been
straightforward. However, one report we are working on requires a datasource that points to a SQL text (i.e., property window shows datasource SelectCommand
property set to the SQL text, SelectCommandType Text). The challenge we are running into is to get this text to accept a parameter; in particular, a string
parameter. Everything works fine when the datasource references a SQL Server database for both String and Int32 parameters, as well as Oracle when using an
Int32 parameter. We discovered that using a colon ":" prefix on the parameter for Oracle works, whereas the "@" prefix works for SQL Server. However, the
"fun" begins when using a String parameter with Oracle. Each time with do so (prefixing the parameter with a ":" as with an Int32 parameter), we get the
following error message: An error has occurred while processing Report "": ORA-12704:character set mismatch. The SelectCommand is something like this
where the SelectCommand references an Oracle varchar2(60) field as a String parameter: "SELECT <field1>, <field2>, <field3>, <field4> FROM Customers WHERE
CustomerName = :custname>." The same SelectCommand slightly adjusted to reference an Oracle Number field as an Int32 parameter works just fine, as with the
following: "SELECT <field1>, <field2>, <field3>, <field4> FROM Customers WHERE CustomerNumber = :customernumber." Only the String parameter version throws
the error mentioned above. How do handle passing a String parameter to Oracle. By the way, the Oracle version we are on is Oracle 8i (8.1.7.4).
Regards,
Curtis Butler
ReportViewer.Report = String.Format("ReportService.{0}, ReportService, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null", App.Current.Resources["Report"]);