VistaDB 5
Gibraltar VistaDB > Developer's Guide > How To Perform Common Tasks > How To - Update Datasets to use VistaDB 5
How To - Update Datasets to use VistaDB 5

Typed Datasets created with VistaDB 4.0 and earlier may fail to open in VistaDB 5.  This is because the Typed DataSet definition includes old connection information in its Xml.  To fix this:

  1. Open the Typed Dataset (.xsd) file in XML mode by selecting Open With.. from the context menu and then selecting XML (Text) Editor from the list.
  2. Near the top find the <Connections> area and at the end of the <Connection /> XML element you'll see the provider listed.  Update it to System.Data.VistaDB5 to use the VistaDB 5 provider.
  3. Save the file and close it.  You should now be able to open it normally in the designer.

 A corrected example of a data set Xsd will have a connection like the following:

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TheEverythingDataSet" 
           targetNamespace="http://tempuri.org/TheEverythingDataSet.xsd" 
           xmlns:mstns="http://tempuri.org/TheEverythingDataSet.xsd" 
           xmlns="http://tempuri.org/TheEverythingDataSet.xsd" 
           xmlns:xs="http://www.w3.org/2001/XMLSchema" 
           xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" 
           xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" 
           attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" 
                  Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" 
                  xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" 
                      IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix="@" 
                      PropertyReference="ApplicationSettings.VistaDB_Sample_App.Properties.Settings.GlobalReference.Default.ConnectionString" 
                      Provider="System.Data.VistaDB5" />
        </Connections>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
</xs:schema>
See Also