REP-177, REP-4100, JDBCPDS-62008 Connection To SQLServer
(Doc ID 456637.1)
Last updated on APRIL 02, 2021
Applies to:
Oracle Reports Developer - Version 10.1.2.0.0 and laterLinux x86
Symptoms
When trying to run a report using JDBC Data Direct Merant drivers to establish connection to SQLServer, you get the following messages:
a) From rwclient command:
$ORACLE_HOME/bin/rwclient.sh report=test.rdf P_JDBCPDS=<user>/<pswd>@<db>:<port> desformat=pdf destype=file desname=/tmp/test.pdf server=<repserver_name>
Failed to execute data source.
JDBCPDS-62008: com.oracle.ias.jdbc.sqlserver.SQLServerDriver
b) From the URL, the report displays errors REP-4100 and JDBCPDS-62008:
http://<server>:<port>/applicationName/jsp/Report.jsp?p_jdbcpds=<user>/<pswd>@<db>:<port>&desformat=html&destype=cache
Wed Aug 30 07:40:33 EDT 2007
javax.servlet.jsp.JspException: rwlib-1: REP-4100: Failed to execute data source.
JDBCPDS-62008:com.oracle.ias.jdbc.sqlserver.SQLServerDriver
at oracle.reports.jsp.ObjectsTag.doEndTag(ObjectsTag.java:206)
at _jsp._testReport._jspService(_testReport.java:74)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:347)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
The same report is working fine on Microsoft Windows platform.
Then environment variable REPORTS_CLASSPATH is set up in reports.sh, as follows:
Changes
SQL Server Merant DataDirect Driver is working on Windows platform using Reports Builder 10.1.2.0.2. It fails on Linux using Reports Server 10.1.2.0.2.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |