> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/webanwendung/datenquellen/endpunkt-anlegen/microsoft-ole-db.md).

# Microsoft OLE DB

The following input fields (required fields) are described below:

### Name

In this input field, a symbolic name of the newly created endpoint is entered.

### Identification

A unique identification is entered here.

### Enabled

If the check box is set, the Microsoft OLE DB endpoint is enabled. Otherwise the endpoint remains disabled.

### Windows Integrated Security

The check box is enabled if the username and password do not need to be explicitly entered for authentication. In this case, the Windows credentials of the user under whom the JUNE5 web server service is running are used. This user must have sufficient rights to read the data from the SQL databases.

{% hint style="info" %}
If the connection to the SQL Server is to be established via **Windows Integrated Security**, you must determine the identity of the Windows user under whom the JUNE5 web server is running. You must then ensure that this user has been granted at least read access to the SQL Server database.
{% endhint %}

### Initial Catalog Required

The check box is enabled if a database name is required in the character string to create the connection to the SQL Server.

### UTC Timestamp

The check box is enabled if the SQL Server evaluates input and output times as UTC times.

### Database Instance Name

In this input field, a name must be specified to uniquely identify the SQL Server instance. This name can be a computer name or can consist of a computer name followed by a backslash and the instance name.

For example: ComputerName\SQLExpress, localhost\SQLExpress or ComputerName.

### Provider Name

The name of the SQL provider is entered here.

For example: MSOLEDBSQL

### Username

In this input field, the name of a user who has sufficient permissions to read the data from the SQL Server databases is entered. The database access is carried out via the Microsoft OLE DB Provider for SQL Server.

### Password

The password for the user specified in the Username field is entered in this field.

### SQL Command Database List

To retrieve the available databases, a SQL statement is entered in this input field. A default statement is already entered. It can be adjusted depending on the SQL provider.

## Test Connection

Using the *Test Connection* button in the horizontal toolbar, the connection to the endpoint can be tested.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.videc.de/june5-3.7/en/webanwendung/datenquellen/endpunkt-anlegen/microsoft-ole-db.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.