Oracle password with Special Charaters

• • Reply

  16 years ago

  by gursheenz

  Guru Prashad

  , India

  Joined 16 years ago

  Hi All,
  

  
  We have a com object(Dll in MTS) where in we open a ADODB connection to a Oracle 8i/9i DB.
  

  
  The connection works fine with normal passwrods(No special Charaters) and fails to connect if we use special charater in the password for Oracle e.g user name = Guru Password =kne#a7T+=/+asq, it works fine if I remove the "+"  "=" "/" sign from the password.
  

  
  Error comes on the statement Conn.open Sconstring.
  

  
  Error = [Microsoft][ODBC driver for Oracle]Failure in DTC: not able to validate open information
  

  
  Where Sconstring value is Provider=MSDASQL;Data Source=MTS2;User ID=CZECH;password =kne#a7T+=/+asq
  Where "MTS2" is the system DSN of type Microsoft ODBC for Oracle.
  

  
  Also the same connection can be opened with out any errors in a standars project, where the oracle password has special charaters, but fails when we try to open the connections from a com object runnig under MTS.
  

  
  App server ( where the Com object is that has the code to open the conneciton)
  MDAC 2.6
  OS Win 2000
  Oracle 8i/9iClient
  

  
  Client
  MDAC 2.6
  OS Win 2000
  

  
  

  
  Thanks,
  Guru Prashad

  Report abuse