Go Back > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 8

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 17th December 2019, 22:33
dostach dostach is offline
Join Date: Dec 2019
Posts: 2
dostach is on a distinguished road
Baan: baan 4 - DB: oracle - OS: Windows
Extracting Data from Baan
Baan: Baan IVc4
DB: Other/Unknown
OS: Windows 2012
C/S: Server

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:

for example:


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.
Reply With Quote
Old 18th December 2019, 13:47
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,482
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I would be looking at how sql server treats the dates INDT and EXDT. There must be a disconnect between how oracle treats them and how sql server treats. I can't remember how they looked from oracle sql query and I no longer have access to query the database that way. Probably need to wait for someone to let you know how to define those date fields for that table in sql server.

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
Old 18th December 2019, 14:15
dostach dostach is offline
Join Date: Dec 2019
Posts: 2
dostach is on a distinguished road
Baan: baan 4 - DB: oracle - OS: Windows
This seems to be issue with all date fields coming from the baan oracle database into the SQL server.
Reply With Quote
Old 18th December 2019, 16:43
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,870
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Linked server !


have a look at.

Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merino Services helps National Cables Industry archive data for Baan IV 100% off-site pritivandana Pages and Stories 0 4th March 2011 19:40
Extracting data from Baan varunnt86 Miscellaneous 0 24th September 2010 06:48
Import Excel data in BAAN (Ver IV) hunzian AFS/DDC/OLE: Function servers 2 19th November 2009 07:58
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
Fehlerhafte Rabattfindung in C4 Kai's Forum Users Deutsches Forum 2 9th January 2001 00:00

All times are GMT +2. The time now is 11:05.

©2001-2020 - -