topic Re: SQL Query not working with OLE DB in App Development

SQL Query not working with OLE DB

kaldubai — Thu, 26 Oct 2017 07:44:09 GMT

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 *

FROM APPSRO.MTL_SYSTEM_ITEMS_B

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 ?

Sincerely

techvarun — Thu, 26 Oct 2017 07:51:59 GMT

I don't think you need to change the code.

have you checked your OLEDB Driver? are you able to connect to the database server using OLEDB?

kaldubai — Sun, 29 Oct 2017 06:39:42 GMT

@varun

i am able to connect to the database and fetch the data but with out Where clause.

Sincerely

vinieme12 — Sun, 29 Oct 2017 09:29:38 GMT

can you post screenshots of the error mesg?

kaldubai — Sun, 29 Oct 2017 14:16:37 GMT

The below screen shot while using oledb:

i have tried to change the format of the date passed to the variable in multiple ways but it was of no use.

the below screen shot while using odbc

techvarun — Mon, 30 Oct 2017 04:08:10 GMT

Have you checked the below threads?

vinieme12 — Sun, 05 Nov 2017 08:49:12 GMT

remove the single quotes

$(Last_updated_Date)

vinieme12 — Sun, 05 Nov 2017 08:54:18 GMT