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


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/ 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.

b) From the URL, the report displays errors REP-4100 and JDBCPDS-62008:


Reports Error Page
Wed Aug 30 07:40:33 EDT 2007

javax.servlet.jsp.JspException: rwlib-1: REP-4100: Failed to execute data source.
at oracle.reports.jsp.ObjectsTag.doEndTag(
at _jsp._testReport._jspService(
at com.orionserver.http.OrionHttpJspPage.service(
at oracle.jsp.runtimev2.JspPageTable.service(
at oracle.jsp.runtimev2.JspServlet.internalService(
at oracle.jsp.runtimev2.JspServlet.service(
at javax.servlet.http.HttpServlet.service(
at com.evermind.server.http.ServletRequestDispatcher.invoke(

The same report is working fine on Microsoft Windows platform.

Then environment variable REPORTS_CLASSPATH is set up in, as follows:


SQL Server Merant DataDirect Driver is working on Windows platform using Reports Builder It fails on Linux using Reports Server


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

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