anyone know nice solution encrypt password in connectionstring?
when i'll go normal way sybase/sap tools can connect dbisql.exe @encrypted_config_file.cfg
in encrypted_config_file.cfg informations servername, user , password stored. can encyrpt file dbhide.exe. database server can connect without telling user real password.
anyone solution in java or c, in connection string option or parameter
--using jconn3.jar drivermanager.registerdriver((driver) class.forname( "com.sybase.jdbc3.jdbc.sybdriver" ).newinstance() ); con = drivermanager.getconnection("jdbc:sybase:tds:hostname:port?servicename=servername", "user", "password");
from sybase info-center site, seems need following:
string url = "jdbc:sybase:tds:myserver:3697"; properties props = new properties(); props.put("encrypt_password ", “true”); props.put("jce_provider_class", "org.bouncycastle.jce.provider.bouncycastleprovider"); /* set additional connnection properties needed */ props.put("user", "xyz"); props.put("password", "123"); /* connection */ connection con = drivermanager.getconnection(url, props);
hopefully helpful.
Comments
Post a Comment