atchawad
8th October 2008, 09:21
Hi all,
I installed Baan IVC4 on MS SQL 2005 .After installed we found the error 205.
After I added MSQL_LEVEL1=0 parameter at ' Maintain database definition'
Then we found new error as:
Env baan (c:\baan)
Prog msql7 file \MSQL\msql_error.c # 681
Keyword MSQL Error
dbs_errno = 1000, Error 1000 occurred:
See fatal SQL statement in 'c:/baan/log/log.msql.mesg'.
Error sqlcode 0 (sqlstate: 07006, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation
Flushed at \MSQL\msql_error.c : #544.
When I check from 'c:/baan/log/log.msql.mesg' it shown sql statement such as :
SQL :
SELECT a.t_cisq,a.t_cldo,a.t_clri,a.t_codl,a.t_csiq,a.t_drun,a.t_frlo,a.t_iilc,a.t_ioer,a.t_logr,a.t_logt,a.t_moei,a.t_prtr,a.t_rdbi,a.t_rdbo,a.t_rdsq,a.t_rmsq,a.t_roei,a.t_rouc,a.t_sern,a.t_sloc,a.t_stig,a.t_stit,a.t_sunu,a.t_swrh,a.t_take,a.t_uolo FROM dbo.ttdilc000200 a WITH ( FASTFIRSTROW)
Is there anybody out here that knows why ?
Any advise is appreciated
I installed Baan IVC4 on MS SQL 2005 .After installed we found the error 205.
After I added MSQL_LEVEL1=0 parameter at ' Maintain database definition'
Then we found new error as:
Env baan (c:\baan)
Prog msql7 file \MSQL\msql_error.c # 681
Keyword MSQL Error
dbs_errno = 1000, Error 1000 occurred:
See fatal SQL statement in 'c:/baan/log/log.msql.mesg'.
Error sqlcode 0 (sqlstate: 07006, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation
Flushed at \MSQL\msql_error.c : #544.
When I check from 'c:/baan/log/log.msql.mesg' it shown sql statement such as :
SQL :
SELECT a.t_cisq,a.t_cldo,a.t_clri,a.t_codl,a.t_csiq,a.t_drun,a.t_frlo,a.t_iilc,a.t_ioer,a.t_logr,a.t_logt,a.t_moei,a.t_prtr,a.t_rdbi,a.t_rdbo,a.t_rdsq,a.t_rmsq,a.t_roei,a.t_rouc,a.t_sern,a.t_sloc,a.t_stig,a.t_stit,a.t_sunu,a.t_swrh,a.t_take,a.t_uolo FROM dbo.ttdilc000200 a WITH ( FASTFIRSTROW)
Is there anybody out here that knows why ?
Any advise is appreciated