3765612 - JDBC connection from SAP Datasphere to SAP IQ fails with "Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver" - SAP IQ

JDBC connection from SAP Datasphere to SAP IQ fails with following error.

--framework.trc
...
2026-05-26 06:19:09,377 [INFO ]  DPFramework | JDBCService.start [] - Starting JDBC service.
...
2026-05-26 06:26:30,580 [ERROR] [a016b56f-761f-4fd3-ab70-a5ab91b6a3d915666] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas.org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver'
...
2026-05-26 06:26:30,590 [ERROR] [a016b56f-761f-4fd3-ab70-a5ab91b6a3d915666] SDAAdapterDelegate | ExceptionUtil.newAdapterException [] - Failed to browse metadata. Reason: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver'org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[86E71FF73174F15-0000000000000000]
...
2026-05-26 06:26:30,595 [ERROR] [a016b56f-761f-4fd3-ab70-a5ab91b6a3d915666] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: [Driver error] Failed to browse metadata. Reason: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver' Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[86E71FF73174F15-0000000000000000]
...
2026-05-26 06:29:25,401 [INFO ] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] DPFramework | WorkerThread.processAdapterOpen [] - Open request for AAA.IQ
2026-05-26 06:29:25,401 [INFO ] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] CamelAdapter | CamelAdapter.open [] - Open remote source [AAA.IQ]. Parameters: {localDriverFolder=, pds_use_agent_stored_credential=false, db_credential_user=BBB, url=jdbc:sybase:Tds:xxx.xxx.xxx.xxx:2638, filename=, filepath=, dbname=, port=, db_security_properties_password=******, driverClass=com.sybase.jdbc4.jdbc.SybDriver, dbtype=other, host=, servername=, db_credential_password=******, remote_source_name=AAA.IQ}
2026-05-26 06:29:25,795 [INFO ] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] SDAAdapterDelegate | SDAAdapterDelegate.initParameter [] - Remote source [AAA.IQ]: {filename=samples/sample-jdbc-dialect.xml, delimident=true}
2026-05-26 06:29:25,999 [INFO ] [d206e56f-218d-4ba7-976e-bb694dd3ffe06053] DPFramework | WorkerThread.processAdapterOpen [] - Open request for AAA.IQ
2026-05-26 06:29:26,004 [INFO ] [d206e56f-218d-4ba7-976e-bb694dd3ffe06053] CamelAdapter | CamelAdapter.open [] - Open remote source [AAA.IQ]. Parameters: {localDriverFolder=, pds_use_agent_stored_credential=false, db_credential_user=BBB, url=jdbc:sybase:Tds:xxx.xxx.xxx.xxx:2638, filename=, filepath=, dbname=, port=, db_security_properties_password=******, driverClass=com.sybase.jdbc4.jdbc.SybDriver, dbtype=other, host=, servername=, db_credential_password=******, remote_source_name=AAA.IQ}
2026-05-26 06:29:26,319 [INFO ] [d206e56f-218d-4ba7-976e-bb694dd3ffe06053] SDAAdapterDelegate | SDAAdapterDelegate.initParameter [] - Remote source [AAA.IQ]: {filename=samples/sample-jdbc-dialect.xml, delimident=true}
2026-05-26 06:29:26,729 [ERROR] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas.org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver'
...
                     ...
2026-05-26 06:29:26,736 [ERROR] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] SDAAdapterDelegate | ExceptionUtil.newAdapterException [] - Failed to browse metadata. Reason: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver'org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[78A1FC2125C6A91-0000000000000000]
...
2026-05-26 06:29:26,736 [ERROR] [67b26069-6734-4a5b-bcae-d3f5b2b45dbb42297] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: [Driver error] Failed to browse metadata. Reason: Cannot load JDBC driver class 'com.sybase.jdbc4.jdbc.SybDriver' Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[78A1FC2125C6A91-0000000000000000]
...
2026-05-26 07:16:20,050 [ERROR] [634f7998-b6d3-47ee-b61e-e119326526bd99391] SDAAdapterDelegate | ExceptionUtil.newAdapterException [] - Failed to browse metadata. Reason: Cannot create PoolableConnectionFactory (JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).)org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[9417323F75ED72A-0000000000000000]

• SAP IQ 16.1
• SAP Datasphere

datasphere, file spaces, generic jdbc, sybase iq, sap iq, jconnect, jconn4.jar, classpath, com.sybase.jdbc4.jdbc.SybDriver, jz00l, hy000, dpAdapterAccess, browse metadata, login failed , KBA , BC-SYB-IQ , Sybase IQ , DS-DI-CON , Connections , Problem