Extracting Data from Baan
Baan: Baan IVc4
OS: Windows 2012
We have set up the BAAN Oracle Server (not sure which version of Oracle) at moment as a linked server in Microsoft SQL Server to do some data processing. We have having problems though as queries that include date field are returning errors:
returns the following error message
Msg 8114, Level 16, State 8, Line 2
Error converting data type DBTYPE_DBTIMESTAMP to datetime2.
I am seeking help since we are trying to do some data processing outside Baan for the data.