7 Replies Latest reply: Nov 5, 2017 3:54 AM by Vineeth Pujari RSS

    SQL Query not working with OLE DB

    kk kk

      Hello Community,


      i have been trying this simple sql query while using OLE DB but it was throwing errors  but when i changed the connection to ODBC

      it worked just fine


      here is the query that i have been working on :


      Sql SELECT *


      WHERE TO_DATE(LAST_UPDATE_DATE,'DD-MON-RR') >= '$(Last_updated_Date)';


      does anyone know why its working with odbc but not oledb ?

      do i have to apply modification in order to get it working with oledb ?