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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 84

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,422
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
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,844
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
Sponsored Links

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 10:47.

©2001-2018 - -