Author Topic: instalation sql server  (Read 783 times)

gkrusty

  • Newbie
  • *
  • Posts: 1
    • View Profile
instalation sql server
« on: February 22, 2010, 05:15:06 AM »
I am installing konakart 4.2.0.1 (Windows) on SQL Server 7.00 and I get this error message during installation :

Code: [Select]
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

  • Administrator
  • Sr. Member
  • *****
  • Posts: 203
    • View Profile
    • KonaKart Website
Re: instalation sql server
« Reply #1 on: February 22, 2010, 07:07:33 AM »
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.