janeza
18th February 2002, 13:54
Thaks all of you to be cooperative with my first question on this
topic.
The problem is that this is not an ordinary upgrade but
upgrade with a new instance on MSQL 2000.
Database bandb was transfered to this new instance with
Copy database wizard. The database was succesfully transfered
to this new instance with the same name (baandb)
I tested with isql if the new instance has a contact with the OS.
select @@version answers positive.
How can we say to Baan to use database on this instance instead of the old database on MSQL 7.0.
As I know file on {BSE}/lib, "tabledef6.1" , has information about that.
example:
cfcec000:*:msql7(MSQL_LEVEL1=1,MSQL_SERVERHOST=SRV1):Y
Say that SRV1 is name of host and SQLServer_name.
Say that our instance on MSQL2000 is INSTBAAN.
As I understand this, a new one have to be like:
cfcec000:*:msql7(MSQL_LEVEL1=1,MSQL_SERVERHOST=SRV1\INSTBAAN):Y
Am I wright with the syntax ?
The second problem is the port number at which SQL2000 listens.
Instalation lets this number to 0 and said that it is dynamic assigned.
Is anywhere else in Baan {BSE}/lib flat files that have to be
changed in respect to the new instance.
Has anyone any experiences with this problem ?
Best regards.
topic.
The problem is that this is not an ordinary upgrade but
upgrade with a new instance on MSQL 2000.
Database bandb was transfered to this new instance with
Copy database wizard. The database was succesfully transfered
to this new instance with the same name (baandb)
I tested with isql if the new instance has a contact with the OS.
select @@version answers positive.
How can we say to Baan to use database on this instance instead of the old database on MSQL 7.0.
As I know file on {BSE}/lib, "tabledef6.1" , has information about that.
example:
cfcec000:*:msql7(MSQL_LEVEL1=1,MSQL_SERVERHOST=SRV1):Y
Say that SRV1 is name of host and SQLServer_name.
Say that our instance on MSQL2000 is INSTBAAN.
As I understand this, a new one have to be like:
cfcec000:*:msql7(MSQL_LEVEL1=1,MSQL_SERVERHOST=SRV1\INSTBAAN):Y
Am I wright with the syntax ?
The second problem is the port number at which SQL2000 listens.
Instalation lets this number to 0 and said that it is dynamic assigned.
Is anywhere else in Baan {BSE}/lib flat files that have to be
changed in respect to the new instance.
Has anyone any experiences with this problem ?
Best regards.