Hi Friends,

While loading BaaN, SQL2000 is not shown as a DBMS in option list.Then how do we load BaanIV with SQL2000 as database ?
I tried installing BaaN on SQL7 and upgrading to SQL2000. But upgradation to SQL2000 failed.

One possible workaround is to load Baan on SQL7,take dump of '000' company, uninstall SQL7, load SQL2000 and post dump of '000' company.

Is there any other way to do a fresh installation of BaaNIVc4 on SQL2000 ?


Thanx and Regards,
Rahul.

Rahul

I have a baan guide on this that says the installer does not support sql2000 and you have to install sql7 and then upgrade.
The guide is to big to post, I can email if required.


Darren

******************************************************

Subject: MergeProject: BaanIVc: # 11626 (BDNT5545): Fixes for problems in
installer for SQL Server 2000
Status: RO

Script: MergeProject
Product: tools
Release: BaanIVc
Type: bugfix

Problem:
Problem Description (Customer terms)
------------------------------------
1. BaanIV installer fails to install with SQL Server 2000 giving a message
:
"SQL Server is not configured with binary sort order. Please use the
'Rebuild Master Database' option in SQL Server setup to change SQL Server's
sort order to 'binary' and restart the Baan installation. "
2. create tables, drop tables, create indexes and import tables functions
fail.


Problem Description (Technical terms)
-------------------------------------
1.The problem occurs in ServerHasBinarySortOrder function of msqladm.cpp.
The SQL-DMO configuration value SQLDMO_DefaultSortOrderId is no more
available and hence the method GetItemByID(SQLDMOConfig_DefaultSortorderId,
&pConfigValue)of LPSQLDMOCONFIGVALUES doesn't work with SQL Server 2000.

2.isql utility is used to create and drop tables and indexes. isql has
been
relocated to ...\Microsoft SQL Server\80\tools\binn in SQL Server 2000
which
was earlier in ...\Microsoft SQL Server\MSSQL directory. We read it from
SQLRootPath property of SQL-DMO object for SQL Server 7.0 and this property
is not available for SQL Server 2000 and hence isql can't be started from
the installer.

Workaround
----------
None

Solution
--------
1. The method of SQL-DMO object Registry is used to retrieve the sort
order.
String comparision is used to check the sort order for SQL Server 2000.
It might be a good idea to enhance this code in future to use extended
SQL-DMO objects which are available SQL Server 2000 onwards.
2. The path prefixed to isql command is removed with an assumption that
the
path is set by SQL Server itself after successful installation.

Test Procedure
--------------
Install with the media having msql7adm.dll with fix.
(OR)
1. Build the latest msql7adm.dll
2. Start the setup.exe from the existing install media(without the fixed
msql7adm.dll). As the first dialog appears, go to the temp directory
(typically c:\winnt\temp) and replace the msql7adm.dll with the latest
binary.
3. Continue with the setup