I am installing konakart 4.2.0.1 (Windows) on SQL Server 7.00 and I get this error message during installation :
INSERT INTO kk_api_call (name, description, date_added) VALUES ('importDigitalDownload','', getdate())
DROP FUNCTION KK_IF
Message: LĂnea 1: sintaxis incorrecta cerca de 'FUNCTION'.
SQLState: 37000
ErrorCode: 170
_____________________________________________________________
SQL execution failed.
What version of sqlserver is supported by Konakart?
How can I solve this problem?
Thanks. Best Regards.
So it appears that SQL Server 7 doesn't support FUNCTION definitions. You'll need a more recent version of SQL Server that supports those. I'm not certain when they introduced support for FUNCTIONs.. but SQL Server 7 is pretty old now (? 1998). I know that SQL Server 9 (SQL Server 2005) works fine so I expect that newer versions also work... SQL Server 8 (SQL Server 2000) may also work, but I haevn't tried it myself.