SAP Knowledge Base Article - Preview

1404162 - Crystal reports using JDBC connect to SQLServer, got the error: Invalid argument for database.

Symptom

Crystal reports using JDBC driver connect to SQLServer, runs fine in the Crystal Reports, but when view it on CMC or Infoview, get this error: Invalid argument for database.

On the server end, you already modified the CRConfig.xml under the bobje/java folder by the following:

  1. Add the sqlserver jdbc jar file to the CLASSPATH
  2. Add the following entry for SQLserver under the <GenericJDBCDriver> section
      <SQLSERVER>
       <ServerType>SQLSERVER</ServerType>
       <QuoteIdentifierOnOff>OFF</QuoteIdentifierOnOff>
       <DriverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</DriverClassName>
       <StoredProcType>Standard</StoredProcType>
       <LogonStyle>MySQL</LogonStyle>
      </SQLSERVER>

The report still fails with the same error.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

JDBC, SQLServer, invalid argument , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.