Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Polls and Surveys

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

View Poll Results: Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4?
Yes 44 83.02%
No 3 5.66%
Don't care 6 11.32%
Voters: 53. You may not vote on this poll

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 5th March 2003, 13:14
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4?

The following was posted earlier by EdHubbard but I thought it was worth to turn it into a poll in which case it could highlight the importance of his message.

If this is an important topic to you then I suggest you cast your vote and/or comments!

Quote:
There are a number of users who have been given the impression that a level 2 driver for SQL server 2000 on 4c4 was on its way but we have recently been told that it is never to be developed.
I discovered this when I was looking around for something else but chanced upon solution 131609 which contradicted what I had read before and been told by Baan personnel. The relevant bit in the solution, and I quote:

"Baan IV :
_________
Baan has not planned to deliver a level 2 driver for SQL Server 2000 and switching to level 2 mode using porting set 6.1c.06.06 or onwards will not work (despite what is mentioned in solution 129671) !
db_resource file examples for Level 2 shown in document :
U7648A US BAAN IV/BaanERP SQL Server 2000 Upgrade Guide for BAAN IV and BaanERP
are only relevant for iBaanERP.
Reference to level 2 mode in document :
U7210B US Baan IVc Installation Guide for Microsoft SQL Server Version 2000
is not relevant."

As there is a level 2 driver for SQL Server 2000 on Baan 5 and a level 2 driver for Oracle on Baan 4, I would have thought developing one for SQL Server 2000 on Baan 4 would not be a mountainous task.

As support for Baan 4 is planned until 2008, there are a number of users that will not migrate to Baan 5 or Gemini for a few years at least.
Please, Baan, have a change of heart!
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Sponsored Links
  #2  
Old 7th March 2003, 04:41
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
I am going to take this issue to the next Baan World Users performance subcommittee meeting and see if we can write this up as a formal enhancement request to get a response back from Baan.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
  #3  
Old 7th March 2003, 07:13
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Smile What's a level 2 driver?

Dear all,

I was about to ask a silly little question: what's a level 2 driver? (please excuse me, I'm from functional side). But then I found this explanation from OmeLuuk:
Difference between Informix Level 1 - Level 2 drivers
Thanks, OmeLuuk

Rgds,
Paul
  #4  
Old 27th March 2003, 14:58
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Just bumping this thread again. Looks like there's not that much interest in a L2 driver? Or else people are reluctant to vote?
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
  #5  
Old 27th March 2003, 16:22
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Unhappy Bad luck

Pat (and others),

I have had a long to and fro chat via email with Baan on whether or not there should be an official Baan statement on the MSQL L2 driver for BaanIV. They decided in the end that the solution should be clear enough, it was never planned, and it will not come.

On personal title I feel that a little motivation would help to accept Baan's point of view. So here it is:

There is a technical problem within MS SQL server in the implementation of the L2 mode.

MS SQL server Level 2 does have a problem when this statement comes by:
Code:
select a from b order by index_x, field_y
in case field_y is a part of index_x. Other level 2 databases does not have a problem with this, MS does.

This was found in the test for iBaan ERP, there it has been changed in the application. Tools were used to do so. There are a lot more places that need to be changed in Baan IV and the tools are useless for that version. Also the installed base is bigger, so more people would suffer from the big solution dump.

Microsoft was involved in this, but in the end it was decided that Baan was to solve it in the application. Also the option to solve it in the tools was turned down.

Hopes this clarifies Baan's position a bit.
__________________
Also read Luke 24:4-8
  #6  
Old 27th March 2003, 19:05
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
My opinion

I think Baan should have provided a statement on this as to "bury" what effectively is an announcement (as previous documentation had indicated there was going to be this L2 driver) in a solution is not good practice.

However your information sounds good enough to me but.....

If you refer to solution 158947 relating to the operation of a find type operation in a session, it looks to me like there is no permanent solution proposed other than changing to an L2 driver. I am not sure if there are any other similar problems lurking......... and remember IVc4 is supported until 2008!

OmeLuuk, Thanks for finding out though
  #7  
Old 28th March 2003, 14:22
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
There you got a point in that solution...
I have been told that if customers want L2 there are good alternatives for MSQL.

As I understand Baan well enough: the discussion between development and PEG is still pending. Something may change over time, but there are more indications that no L2 driver will be made. Money is one part of the story, effort (not in the least place effort to install the huge solutions) is the other part.

After all it is a political discussion where also Baan's position in relation with MS is involved, imho.

But in the end: actually Baan is not the problem, the problem lies with MS being not capable in handling the order by statement. Other DBMS'ses can do what MSSQL cannot do.
__________________
Also read Luke 24:4-8
Closed Thread


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
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
Baan Oracle* Driver Performance Problems pshaw1 Performance & Tuning 7 25th February 2004 16:27
Segregating tools company 000 vanwinkle Operating Systems & Databases 7 5th February 2002 15:22
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 22:55
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44


All times are GMT +2. The time now is 23:03.


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