Good morning,
Apologies for the username (if it is still showing strangely), this is my first post in these forums I hope I've posted in the correct place.
I have written an application which uses ADO to connect to an Oracle database to perform a query, which i then later can alert on. I have tested this on a server running Oracle 11g and if I use the ODBC method of connection (Oracle in OraDB11g_home1 driver 64bit) my query returns results absolutely fine. If however I use the OLEDB Provider method my query either does not return anything or sometimes I can seem to return the first row but nothing else. I have numerous querys of which the majority are absolutely fine using both methods however this one particular query does not seem to work.
Select Submission_Session_ID,Acquirer_ID,TO_CHAR(Submission_Date,'DD Mon YYYY HH24:MI'),Total_Records,Status,round(Total_Net_Debit-Total_Net_Credit/100.0,2)
FROM customer.SubmissionHistory
WHERE Submission_Date >= (sysdate-1/24)
Are there limitations to using this connection method that will impact the way my results return?
Kind regards
Rob Cole
Oracle