• Welcome to KonaKart Community Forum. Please login or sign up.
 

instalation sql server

Started by gkrusty, February 22, 2010, 10:15:06 am

Previous topic - Next topic

gkrusty

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.



heidi

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.