SQLCL version 20.4 and Oracle Client 21.3 (64 Bit and 32 Bit) on my Windows 10 server
Contents of my .bat file to launch sqlcl:
set PATH=C:\Users\a13041p\Documents\instantclient\instantclient_21_3_64Bit;%PATH%
C:\Users\...\sqlcl-20.4.2.35.2359\sqlcl\bin\sql.exe
I submit the connect string as:
jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost-scan)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TAFTEST)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))
With PATH pointing to 64Bit Oracle Instant Client I get Error Message = C:\Users\a13041p\Documents\instantclient\instantclient_21_3_64Bit\ocijdbc21.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform
With PATH pointing to 32Bit Oracle Instant Client Error Message = Incompatible version of libocijdbc[Jdbc:211000, Jdbc-OCI:213000