how can i connect to oracle via OLEDB with cripted connection? RSS

• • Reply
  

  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
  

  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;

  
   

  www.immobilzero.com (free estare web site)
• • Reply
  

  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

  I learn by helping others. I may not always be correct but my intentions are good. If my answer helps please mark it as so.