ADS 20.x can't connect to Sybase iAnywhere because multiple dbjdbc12.dll, dbjdbc16.dll, and dbjdbc17.dll files were found in directories configured in the system PATH.
Sybase iAnywhere comes with multiple Sybase client tool as listed below:-
SAP IQ
SAP ASE
SQL Anywhere
And all these client tools comes with 32 bit and 64 bit jar files of sajdbc.jar. He can't remove this from PATH variable because other programs that look for these clients and 32 bit version will fail to work. He tested this and when he remove it from PATH, Aqua data studio works but other programs don’t.
Support Info:
141 KB
I've attached screen shot of error but blacked out URL information. If this is needed let me know and I'll email unaltered screen shot.
From Asif's analysis...
The dlls are loaded by the Sybase iAnywhere jdbc driver. The jdbc driver picks it from the system PATH variable. If there are multiple dlls in the path it can cause a hang or unexpected behavior while using the JDBC connection. Hence we check for the multiple dll in path scenario specifically in SybaseAnywhereNativeLibrary > checkAvailability
From Asif's analysis...
The dlls are loaded by the Sybase iAnywhere jdbc driver. The jdbc driver picks it from the system PATH variable. If there are multiple dlls in the path it can cause a hang or unexpected behavior while using the JDBC connection. Hence we check for the multiple dll in path scenario specifically in SybaseAnywhereNativeLibrary > checkAvailability
Issue #15860 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
I've attached screen shot of error but blacked out URL information. If this is needed let me know and I'll email unaltered screen shot.