in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Faled to load dataset designer

Last post 11-11-2008 5:18 AM by SalarWeb. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 11-11-2008 5:18 AM

    Faled to load dataset designer

    Hi

    I'm using the latest release of SQL.NET and it's designer for VS2005.

    The problem occurs when i'm using Dataset designer.

    In dataset first creation, with a table that dropped from ServerExplorer with SQLite database, it works. but after closing and opening dataset again, it failes with this error.

    Failed to load dataset because of the following error:
    Key not valid for use in specified state.

    I went after this to see what is wrong, and i found that the designer failed to get list connections in the project.

    I opended Dataset file in notepad and removed "Connections" section. After that the designer worked, but still had error with TableAdapters editing .

    I removed this section:

    <Connections>
     <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ChequeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ChConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ChPrinter.Properties.Settings.GlobalReference.Default.ChConnectionString" Provider="System.Data.SQLite">
     </Connection>
    </Connections>

    I just want to report the error.

    Thanks anyway

Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems