Oracle SQL Query Returns Different Results via OLEDB Provider as Opposed to ODBC 10/11g Driver -


I have written a small application in the Autoclot scripting language, which uses ADO to run Oracle and MSSQL database and query Does, alert on your results?

Most of the time I can connect to an Oracle DB using the ORCB and standard 10/11G driver but this can not be done on one of my clients' servers, so I'm using it I'm the OLEDB provider as the connection method.

The query I am using does not return any results through the OLEDB, although it works perfectly well via ODBC.

  Submission_Session_ID, Acquirer_ID, TO_CHAR (Submission_ Date, 'DD Mon YYYY HH24: MI'), Total_cards, Status, Round (total_net debit-total_net credit / 100.0.2) from Customer.Assignment Date Submission_ Date & Gt; = (Sysdate-1/24)  

Does anybody understand why this may be the case? Too much I am able to return a line with this question.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -