Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th April 2002, 19:40
wangxn wangxn is offline
Junior Member
 
Join Date: Sep 2001
Posts: 3
wangxn is on a distinguished road
Unhappy Date Field Error during Load Oracle Data into Microsoft SQL server through ODBC

For the Date field in Baan(we use Oracle database), if it is empty, Baan store it as 01-01-9999, which is not suport by microsoft SQL sever.
i need to download the baan data into SQL server, but date field is always problem, Baan said i should write a view for that, but i don't think it is practical since i am not sure when and what table i need to download and besides, Baan has so many tables, every table has the same problem if date field is empty.

Any body has bright idea on how to write a VB script, for instance to check the date field during loading, let's say i am using DTS tranform function of Microsoft SQL Server.
__________________
regards,
Reply With Quote
Sponsored Links
  #2  
Old 11th April 2002, 14:05
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Parameter oradate

You can first download the whole base, change the oradata parameter in db_resource like this oradate:1 and reload the base.
After that the date will be stored as 1 JAN 4712BC.

There is a case opened in the baan KB.

Regards
Reply With Quote
  #3  
Old 11th April 2002, 14:07
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Parameter is ora_date:1

Sorry.
Reply With Quote
Reply


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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Baan null date field view from oracle sql zaidlaz Tools Development 9 21st June 2006 17:13
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11


All times are GMT +2. The time now is 13:47.


©2001-2017 - Baanboard.com - Baanforums.com