Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 21, 2012 11:11 AM by cornball76
Member
178 Points
383 Posts
Dec 21, 2012 09:15 AM|LINK
hi there
i need to connect to oracle via OLedb or ODBC or OraOLEDB
how can i set my cripted password in the connection? i found a script used in another server in my company written in JAVA but i need to use oledb, this is the script
Properties connectionProperties = new Properties();
connectionProperties.put("NAMES.DIRECTORY_PATH", "(*******)"); connectionProperties.put("SQLNET.ENCRYPTION_CLIENT", "accepted"); connectionProperties.put("SQLNET.CRYPTO_CHECKSUM_CLIENT", "accepted"); connectionProperties.put("SQLNET.CRYPTO_SEED", "******************"); OracleDataSource oracleDataSource = new OracleDataSource(); oracleDataSource.setConnectionProperties(connectionProperties); oracleDataSource.setURL(Constants.***********); oracleDataSource.setUser("*****"); oracleDataSource.setPassword("**********"); connection = oracleDataSource.getConnection(); dsSCCR03 = oracleDataSource;
Participant
1126 Points
210 Posts
Dec 21, 2012 11:11 AM|LINK
Take a look here.
http://www.beansoftware.com/ASP.NET-Tutorials/Encrypting-Connection-String.aspx
amodius
Member
178 Points
383 Posts
how can i connect to oracle via OLEDB with cripted connection?
Dec 21, 2012 09:15 AM|LINK
hi there
i need to connect to oracle via OLedb or ODBC or OraOLEDB
how can i set my cripted password in the connection?
i found a script used in another server in my company written in JAVA
but i need to use oledb, this is the script
connectionProperties.put("NAMES.DIRECTORY_PATH", "(*******)"); connectionProperties.put("SQLNET.ENCRYPTION_CLIENT", "accepted"); connectionProperties.put("SQLNET.CRYPTO_CHECKSUM_CLIENT", "accepted"); connectionProperties.put("SQLNET.CRYPTO_SEED", "******************"); OracleDataSource oracleDataSource = new OracleDataSource(); oracleDataSource.setConnectionProperties(connectionProperties); oracleDataSource.setURL(Constants.***********); oracleDataSource.setUser("*****"); oracleDataSource.setPassword("**********"); connection = oracleDataSource.getConnection(); dsSCCR03 = oracleDataSource;cornball76
Participant
1126 Points
210 Posts
Re: how can i connect to oracle via OLEDB with cripted connection?
Dec 21, 2012 11:11 AM|LINK
Take a look here.
http://www.beansoftware.com/ASP.NET-Tutorials/Encrypting-Connection-String.aspx