| Author |
Messages |
|
roland.thoeni
Posts:3
 |
| 12/02/2008 2:42 PM |
|
Hello, sorry i can not scribere very good english. I have a problem with Silverlight Desktop in my DNN portal. i send you the fail:
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: Syntax error converting the nvarchar value 'True' to a column of data type bit. 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) /*** Insert Default data ***/ DELETE FROM dbo.SilverlightDesktopModules WHERE (ModuleName = N'WhoAmI') INSERT INTO dbo.SilverlightDesktopModules (ModuleName, ModuleDescription, AssemblyName, ClassName, IconName, [Role], WindowSize, AllowMultipleInstances, ModuleVersion, uninstall) VALUES(N'WhoAmI', N'Displays information about the current user', N'WhoAmI.xap', N'WhoAmI.Page', N'WhoAmI.jpg', N'Any', N'20', N'True', 1, '') .
Job-Ende SQL-Ausführung beendet: Datei 01.00.00.SqlDataProvider
Info Ausführen01.90.00.SqlDataProvider
Starte Job Starte SQL-Ausführung: Datei 01.90.00.SqlDataProvider
Abbruch Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: Line 22: Incorrect syntax near '('. 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) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /****** Object: Table [dbo].[SilverlightNotepad] ******/ IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SilverlightNotepad]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[SilverlightNotepad]( [NoteID] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](50) NOT NULL, [IPAddress] [nvarchar](50) NOT NULL, [Note] [nvarchar](100) NULL, CONSTRAINT [PK_SilverlightNotepad] PRIMARY KEY CLUSTERED ( [NoteID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END DELETE FROM SilverlightDesktopModules WHERE (ModuleName = N'Silverlight Notepad') INSERT INTO SilverlightDesktopModules (ModuleName, ModuleDescription, AssemblyName, ClassName, IconName, [Role], WindowSize, AllowMultipleInstances, ModuleVersion, uninstall) VALUES(N'Silverlight Notepad', N'Allows users to save notes', N'SilverlightNotepad.xap', N'SilverlightNotepad.Page', 'null', N'Any', N'50', N'True', 300000, N'DROP TABLE [dbo].[SilverlightNotepad] END') .
Job-Ende SQL-Ausführung beendet: Datei 01.90.00.SqlDataProvider
What is the Problem? I have the web.config supportet up the new Part and Linq for SQL is installed. Thanks |
|
|
|
|
Michael Washington
Posts:64
|
| 12/02/2008 4:22 PM |
|
It appears that your SQL server is not set to English so it cannot understand the setting of "True".
The only thing I could suggest is that you could change the word "True" (in the 01.00.00.SqlDataProvider script) to a word that it would understand. |
|
|
|
|
roland.thoeni
Posts:3
|
| 12/06/2008 3:07 AM |
|
| Hello Michael. Thanks for your Reply. With the old Version from Silverlightdesktop (1.5) it works, the new Version makes Problems. I think, the Language is not the Problem. Sorry for my Englisch. I am a swiss. |
|
|
|
|
|