Site Creation Wizard: Database Type

The advanced options of the Site Creation Wizard enable you to select the type of database you want to use to store your Site data. Vector AM supports Microsoft Access through Jet, native SQL Server, SQL Server Express and Oracle, or any type of database using ODBC. To work with ODBC, the target database must have a defined Data Source. Vector AM can automatically create Data Sources for Microsoft Access, Microsoft SQL Server and Oracle databases.

To select the type of database you want to use for your Site:

1    Select:

Local Vector Asset Management MSDE Server For a locally installed Microsoft SQL Server 2000 Desktop Engine.

Access For Access 97, 2000 and XP databases.

Oracle For Oracle databases (version 8i or later).

SQL Server/Remote MSDE For SQL Server 7 and 2000, and SQL Server Express 2005 and 2008 databases.

Other ODBC For other ODBC-compliant databases. If you choose this option, you must enter the Data Source Name (DSN) for the database later in the wizard.

2    Click Next to open the Site Creation Options dialog.

Note

The Local Vector Asset Management MSDE Server option is provided for backwards-compatibility with databases created by older version Consoles. It is disabled when no MSDE database is present and MSDE is no longer supported for new databases.