Just encountered a problem installing 1.0.1.0 on a system running SQL2000.
It appears that in order to get the install to work properly with SQL2000 (or at least one customer's implementation of it) you need to modify two of the code lines in xaEmm-Install.aspx.cs
On line 765:
Quote:cmd.CommandText = "CREATE TABLE [dbo].[xaEmmAudiences] ([AudienceID] [int] NOT NULL, [Deleted] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmAudiences_Deleted] DEFAULT ((0)), [TestMode] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmAudiences_TestMode] DEFAULT ((0)), [AudienceDescription] [nvarchar](150) NOT NULL, CONSTRAINT [PK_xaEmmAudiences] PRIMARY KEY CLUSTERED ( [AudienceID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]";
should be changed to read:
Quote:cmd.CommandText = "CREATE TABLE [dbo].[xaEmmAudiences] ([AudienceID] [int] NOT NULL, [Deleted] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmAudiences_Deleted] DEFAULT ((0)), [TestMode] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmAudiences_TestMode] DEFAULT ((0)), [AudienceDescription] [nvarchar](150) NOT NULL, CONSTRAINT [PK_xaEmmAudiences] PRIMARY KEY CLUSTERED ( [AudienceID] ASC ) ON [PRIMARY]) ON [PRIMARY]";
Note that the following has been removed:
Quote:WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
On line 811:
Quote:cmd.CommandText = "CREATE TABLE [dbo].[xaEmmExternalCustomer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [CustomerGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_CustomerGUID] DEFAULT (newid()), [Email] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OkToEmail] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_OkToEmail] DEFAULT ((1)), [UDF1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF4] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF5] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [InsertionDate] [datetime] NULL CONSTRAINT [DF_xaEmmExternalCustomer_InsertionDate] DEFAULT (getdate()), [UnsubscribeDate] [datetime] NULL, [IsRegistered] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_IsRegistered] DEFAULT ((0)), [Notes] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_xaEmmExternalCustomer] PRIMARY KEY CLUSTERED ( [Email] ASC ) ON [PRIMARY] ) ON [PRIMARY]";
should be changed to read:
Quote:cmd.CommandText = "CREATE TABLE [dbo].[xaEmmExternalCustomer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [CustomerGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_CustomerGUID] DEFAULT (newid()), [Email] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OkToEmail] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_OkToEmail] DEFAULT ((1)), [UDF1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF4] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDF5] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [InsertionDate] [datetime] NULL CONSTRAINT [DF_xaEmmExternalCustomer_InsertionDate] DEFAULT (getdate()), [UnsubscribeDate] [datetime] NULL, [IsRegistered] [tinyint] NOT NULL CONSTRAINT [DF_xaEmmExternalCustomer_IsRegistered] DEFAULT ((0)), [Notes] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_xaEmmExternalCustomer] PRIMARY KEY CLUSTERED ( [Email] ASC ) ON [PRIMARY] ) ON [PRIMARY]";
Note that the following has been removed:
Quote:WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90)
Please try the normal install process first but know that if it fails with an error like "incorrect syntax near (" that you'll need to go in and delete the xaEmm* Appconfig parameters, the xaEmm.* StringResources and then re-run the install script after making the above changes!
Exhibit A Communications
http://www.exhibita.com/
