OpenSQL Exception

[Former Member]

Hi,

I have an application trying to create a connection to the database using an OpenSQLDataSource object. I initialize the driver properties and try connecting, and then I get the error below:

com.sap.sql.log.OpenSQLException: JDBC driver not supported for MS_SQL_SERVER database.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.jdbc.direct.DirectConnectionFactory.createContextFactory(DirectConnectionFactory.java:485)

at com.sap.sql.jdbc.direct.DirectConnectionFactory.createDirectConnection(DirectConnectionFactory.java:145)

at com.sap.sql.jdbc.common.CommonConnectionFactory.createConnection(CommonConnectionFactory.java:251)

at com.sap.sql.jdbc.common.CommonConnectionFactory.createCommonConnection(CommonConnectionFactory.java:86)

at com.sap.sql.connect.CommonFactoryLib.createCommonConnection(CommonFactoryLib.java:45)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:513)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:254)

at com.sap.portal.webreport.tools.util.DBWriter.connect(DBWriter.java:132)

at com.sap.portal.webreport.tools.util.DBWriter.<init>(DBWriter.java:65)

at com.sap.portal.webreport.tools.Aggregator.<init>(Aggregator.java:37)

at com.sap.portal.webreport.tools.Aggregator.main(Aggregator.java:393)

Caused by: com.sap.sql.log.OpenSQLException: JDBC driver not supported for MS_SQL_SERVER database.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.jdbc.direct.DirectConnectionFactory.createContextFactory(DirectConnectionFactory.java:477)

... 10 more

The driver and URL are:

URL=jdbc:sap:sqlserver://host:port;DatabaseName=Name

DRIVER_CLASSNAME=com.sap.portals.jdbc.sqlserver.SQLServerDriver

Any ideas why this happening?

I will appreciate any help I can get.

Thanks,

Or

[guru_subramanianb]

Hi Or,

Seems that your driver is not been supported for the DAtabase.Check whether that are you loading the correct driver.

Regards,

Guru