locked
how can i connect to oracle via OLEDB with cripted connection? RRS feed

  • Question

  • User-400329145 posted

    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;
    
    


     

    Friday, December 21, 2012 5:15 AM

All replies

  • User1424224880 posted

    Take a look here.

    http://www.beansoftware.com/ASP.NET-Tutorials/Encrypting-Connection-String.aspx

    Friday, December 21, 2012 7:11 AM