I am using simple sql statement to update an oracle table from vb6 application. some how it doesn't update the table and it doesn't throw any error either.

This is 2 line code I am using

sSQL = "UPDATE A.TABLE1 SET UPDATE_DATE = " & "to_date('" & Format(dCurrentDateTime, "DD-MMM-YYYY HH:MM:SS") & "', 'DD-Mon-YYYY HH24:MI:SS')"

oRS.Open sSQL, cnn, adOpenForwardOnly, adLockPessimistic

when I look in the immediate window, I see
cnn as Provider=MSDAORA.1;Password=tradeu$3r;User ID=at_user;Data Source=cdb.world;Extended Properties="ConnectString=Provider=OraOLEDB.Oracle"
and I also checked the cnn (connection status is open). I am really shocked why this is happening.

Pls throw some ideas ...

thanks
nath