i have been given oracle jdbc thin client connection string information, not able use in navicat. here have:
#ds.url=jdbc:oracle:thin:@ldap://my.url.com:3000/efgh1,cn=oraclecontext,dc=bh,dc=url2,dc=net #ds.username=my_username #ds.password=my_secure_password
here picture of navicat information required:
i've tried every combination of variables , i've search web quite bit, cannot find clear idea of i'm doing wrong.
refer "jdbc developer's guide" more details on ldap syntax. have pasted code snippet here.
properties prop = new properties(); string url = "jdbc:oracle:thin:@ldap://ldap1.example.com:3500/cn=salesdept,cn=oraclecontext,dc=com/salesdb " + "ldap://ldap2.example.com:3500/cn=salesdept,cn=oraclecontext,dc=com/salesdb " + "ldap://ldap3.example.com:3500/cn=salesdept,cn=oraclecontext,dc=com/salesdb"; prop.put("oracle.net.ldap_loadbalance", "off" ); oracledatasource ods = new oracledatasource(); ods.seturl(url); ods.setconnectionproperties(prop);