Microsoft SQL Server Events
Information
Reads entries from a Microsoft SQL Server database table as events.
| Driver Info | Detail |
|---|---|
| Driver Type: | Event |
| Platforms: | All |
Driver Settings
| Option | Description |
|---|---|
| Host | The IP or DNS name of your MS SQL server |
| Port | The port number the server is running on |
| Database | The name of the database |
| Username | The username to sign into the database server |
| Password | The password to go along with the username |
| Table | The name of the table to read events from |
| Name Field | The name of the field that contains the event name |
| Start Field | The name of the field that contains the start date/time |
| End Field | The name of the field that contains the end date/time |
| Duration Field | The name of the field that contains the duration of the event |
| Prefix | A prefix to add to the name of the event |
| Timezone | The timezone for the dates in the database |
Notes
The driver queries the table, and delivers a list of events based on the Name, Start and (optionally) either the End or Duration fields.
Both End and Duration may be empty. The behaviour of the driver will vary.
| Start | End | Duration | Outcome |
|---|---|---|---|
| Y | N | N | Event will be instantanious |
| Y | Y | N | Event will start at 'start' and finish at 'end' |
| Y | N | Y | Event will start at 'start' and end 'duration' seconds later |
| Y | Y | Y | Event will start at 'start' and finish at 'end'. Duration is ignored |