Hi,
i migrate an application from MSSQL server to oracle, i am using ADO to connect to oracle, and I am using ODBC for the connection string, the ODBC oracle driver I am using is 10.0.2.3 (the latest one available at ORACLE website)...
everything works perfect except the time fields.....
if I use any SQL statment with time parameters, it dose not work properly
ex: INSERT INTO MYTABLE (ID, MYTIME, MYDATE, MYDATETIME) VALUES(:ID, :MYTIME, :MYDATE, :MYDATETIME)
when I execute this sql statment, the record is added but always the time is 0... the date is correct.
but if i use normal adodataset and i use adodataset.append - adodataset.fieldbyname... it works and will save teh time
as well this if I use the SELECt statment
ex: select * from mytable where mytime >= :mytime
the result will be all records.... becasue as I think the ODBC did not accept the time and it put it as 0.
any help please
