My Oracle Support Banner

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 later
Linux 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>

REP-0177: Error while running in remote server
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
 

Reports Error Page
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.