Connecting to and Configuring a Repository
The repository engine can access repository databases that are managed by either Microsoft® Jet, Microsoft SQL Server™, or SQL Server Runtime Engine.
The repository engine accesses a database through an ODBC driver (version 2.0 or later). You must have ODBC installed on the server hosting the database and on the client from which you are accessing the repository engine.
The ODBC connection string that is used to specify the location of the repository database varies, depending upon which database server is managing the repository database. The ODBC connection string contains keyword=keyValue pairs, separated by semicolons. If you do not specify a connection string, the repository engine creates a default repository database.
Before you can connect to a database, you must first instantiate a repository session. After you create a repository instance, you can open an existing database or create a new database. Note that how a database is created varies depending on the DBMS you use.
The following table lists topics that tell you more about database connections and configuration.
|Connecting to a SQL Server Repository Database||Describes how to open or create a SQL Server database connection|
|Connecting to a Jet Repository Database||Describes how to open or create a Jet database connection|
|Connecting Through a DSN||Describes how to connect to a repository database through a data source name (DSN)|
|Default Repository Databases||Explains how the repository engine resolves an unspecified connection string by creating a default database|
|Replicating Repository Databases||Describes replication behavior for SQL Server repository databases|