I have downloaded the 4.1 distribution and have been going through the manual steps of install. I am having difficulties installing the sql scripts. I am getting the following error message:

Invalid object ‘sys.foreign_keys’. I am using MS SQL 2000 and note that this table does not exist. I know it does exist in MS SQL 2005. Am I supposed to be using 4.0 or do you have newer sql scripts that I can run?

 

Is it something I have missed?

 

Thanks in advance

 

James

Hello James,

   Have you downloaded 4.1 or 4.1.1 distribution?

   Actually, all ECF 4.x versions should work on both SQL 2000 and SQL 2005 servers.
   I looked into the ECF 4.1.1 installation scripts, and they do not contain any references to sys.foreign_keys, and, furthermore, successfully run on SQL 2000.

   In what script are you getting the error?

Nadya.

Hi Nadya,

I have the same problem, installing 4.1.1 distribution against SQL 2000 server. There is a reference to sys.foreign_keys on this script:

C:\Program Files\Mediachase\eCommerce Framework 4.1\Installation\SqlScripts\DataBaseSchema_Tables.sql

Thanks,
Carina

Hello Carina,

   Please use the attached DataBaseSchema_Tables.sql script instead of the one you have (just replace it in the installation files).

Hope this helps.

Nadya.