Baanboard.com

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

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 19th August 2005, 04:30
gavin_wusj gavin_wusj is offline
Senior Member
 
Join Date: Oct 2003
Location: Shanghai,China
Posts: 111
gavin_wusj is on a distinguished road
Baan: LN - DB: oracle - OS: Sun solaris
How to access data from others database in baan script,e.g SQL Server

Dear all,
Our database of baan is oracle 8i, now I need access data from sql server ,and insert or update to oracle8i, how can I done it?

thanks all.

gavin
Reply With Quote
  #2  
Old 19th August 2005, 13:13
norwim's Avatar
norwim norwim is offline
Guru
 
Join Date: Oct 2001
Location: Germany Moenchengladbach
Posts: 450
norwim is on a distinguished road
Baan: some - DB: more - OS: many
Hi there,

do you have any command line interface to run sql statements on your solaris system? If not, google says: http://www.sommarskog.se/mssqlperl/unix.html
If so, then you could create a sequential file within a baan program. Write the required sql-statements to this file. Call the command line interface to process this file with the shell() command from within the baan program. If you redirect the output of the sql-program to a file, you can again read the results within the baan program.
Not sure on the second part of your question ... if Baan is using oracle8i, what is the problem in writing there? If you want to write to tables not known to the Baan system, use the above method via seq. files.

hth

Norbert
__________________
Have a nice day
Reply With Quote
Sponsored Links
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
How to split Baan Application and Baan Database ? baaniac Operating Systems & Databases 4 2nd June 2009 03:48
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
how to change collation name on baandb database (SQL 2000 Server) nopadon Operating Systems & Databases 0 10th November 2003 11:30
BaaN C4, Windows 2000 Advanced Server and SQL 7.0 Server rdheeraj Operating Systems & Databases 1 30th May 2003 19:32


All times are GMT +2. The time now is 15:49.


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