Connecting to a Database
|
| Previous Top Next |
Connecting to a Database |
When you select either the File | New | New from DB or File | New | New from XML Column in IBM DB2 command, the Open Database dialog (screenshot below) pops up. (Note that the New from DB and New from XML Column in IBM DB2 commands are also available in the Design Overview sidebar.)
The connection to the database is made using one of the options given below:
| • | Using a Connection Wizard that guides you through the connection process. |
| • | Using an ADO connection. |
| • | Using an ODBC connection. |
Each of these options is explained in a separate sub-section of this section.
| Note: | When adding an ODBC Data Source for the IBM iSeries (formerly AS/400), a default flag is set which enables query timeouts. This setting must be disabled for StyleVision to correctly load the SPS. When adding an ODBC data source (User/System DSN) for iSeries Access ODBC driver, the "iSeries Access for Windows ODBC Setup" dialog box is opened. Select the Performance tab, click the Advanced button and uncheck the Allow Query Timeout check box option. |
Selecting the XML data and schema for the SPS
After the connection to the database has been made, the schema and XML data for the SPS must be generated. This is done on the basis of the database structure and data. There are two possible situations:
| • | In the case of non-XML databases, you select the table/s for which the SPS is being created. StyleVision automatically generates: (i) a schema based on the structure of the table/s, and (ii) temporary XML files based on this schema and containing the data in the selected table/s. How to select the tables is described in the section DB Data Selection | Non-XML Databases. |
| • | In the case of XML databases, you must do two things. First, select the XML cell of the DB in which the required XML data is stored. This XML data is loaded as the Working XML File of the SPS. Second, select the schema on which the SPS will be based. How to select the XML data and schema is explained in the section, DB Data Selection | XML Databases. |
See also:
DBs and StyleVision, for a description of how DBs work with StyleVision.
DB Data Selection, for a description of how to select tables or structures in the DB as the schema and data sources.
The DB Schema and DB XML files, for a description of the XML Schema and XML data files that are generated from the DB when it is loaded in StyleVision.
Datatype Conversions: DB to XSD, for mappings of DB datatypes to XSD datatypes when the XML Schema is generated from the DB.
|