I am not using any yet as i cant install it. Appears that both have been installed.
I am using SQL Server 2005.
This is the error I get when I try to install
| StartJob |
Begin Sql execution |
| Info |
Executing 01.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE [dbo].[CuteChat4_SupportAgent] ADD CONSTRAINT [FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment] FOREIGN KEY ( [DepartmentId] ) REFERENCES [dbo].[CuteChat4_SupportDepartment] ( [DepartmentId] ) ON DELETE CASCADE GO |
| EndJob |
End Sql execution: 01.00.00.SqlDataProvider file |
Broke it down and tried to run all statements separately but still no luck.
Appreciate your help.
Thanks
Sarah