0 Replies Latest reply on Aug 14, 2013 7:13 AM by 04779967-b3e5-45ad-884a-594aff5d3f5f

    ADO recordset not working properly after upgrade to 11g


      Hi ,

      I am facing a very weird issue , i am running a sql using the ADO recordset , but i get only one column value in the recordset.

      Other columns values are coming as Null.

      Using as below :


      Set objConnection=Createobject("ADODB.Connection")

      'connection String and query
      strConnString="Provider=OraOLEDB.Oracle.1;Data Source=<DBNAME>;User ID=<UNAME>;Password=<PSWD>;"

      'Establishing connection with DB
      objConnection.Open strConnString

      sql="select t1.colum1,t2.column2,t1.column3 from table t1,table t2 where t1.id=t2.id(+)"'sample sql

      Set rs= Createobject("ADODB.Recordset")
      rs.Open sql,strConnString

      msgbox rs.GetString()

      'msgbox rs(0).value
      'msgbox rs(1).value


      so , In the above code i am only getting the value for t2.column2 .

      It doesnt matter if i use GetString() or GetRows() or iterate throught the recordset.


      If i run the query in Toad i am getting values for all the column in the select clause.I have oracle 11g on windows7.


      Can anybody help with a solution here?