Examples |
|
SqlDrv -> Configuration -> Settings in the driver dialog -> Driver dialog SqlDrv-Variablen -> Examples |
   Show
all  Hide
all |
Examples |
|
SqlDrv -> Configuration -> Settings in the driver dialog -> Driver dialog SqlDrv-Variablen -> Examples |
| Show
all Hide
all |
1. Example
Access:
Table definition
Creating the receive table
2. Example
MS-SQL Server
Create the following table with "Process -> New table".
Format of the receive table
Settings for the index of the receive table
If the database does not support the needed date format, the following definition can be used.
|
Parameters |
Typ |
Description |
|---|---|---|
|
DATUMZEIT |
Text |
Time stamp without milliseconds |
If the database supports the standard date of the operating system, the format can be changed with "Start / Settings / Control Panel / Regional Options".
3. Example
Microsoft SQL Service Management Studio Express
Use of SQL query:
USE [DATABASENAME]
GO
/****** Object: Table [dbo].[zRECEIVE] Script Date: 06/18/2007 15:51:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zRECEIVE](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[NAME] [nvarchar](max) NOT NULL,
[DATUMZEIT] [datetime] NOT NULL,
[ZEIT_MS] [int] NOT NULL,
[WERT] [nvarchar](max) NOT NULL,
[STATUS] [int] NOT NULL,
[ACK_SRV] [int] NULL,
[ACK_SB] [int] NULL,
[INSERTZEIT] [datetime] NULL,
CONSTRAINT [PK_ZENONEMPFANGEN] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Use of SQL query:
USE [DATABASENAME]
GO
/****** Object: Table [dbo].[zSEND] Script Date: 06/18/2007 15:52:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zSEND](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[NAME] [nvarchar](max) NOT NULL,
[DATUMZEIT] [datetime] NOT NULL,
[ZEIT_MS] [int] NOT NULL,
[WERT] [nvarchar](max) NOT NULL,
[STATUS] [int] NOT NULL,
[ACK_SRV] [int] NULL,
[ACK_SB] [int] NULL,
[INSERTZEIT] [datetime] NULL,
CONSTRAINT [PK_ZENONSENDEN] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Redundancy
If the driver is used in redundant operation, the following settings must be considered:
Additional entries in the receive table are required:
|
Parameters |
Typ |
Description |
|---|---|---|
|
Name |
Data type |
Usage |
|
ACK_SRV |
Number |
Set to 1 after configured server has read |
|
ACK_SB |
Number |
Set to 1 after configured standby server has read |
|
INSERTZEIT |
Date/Time |
Standard value Now(), time of insertion of the line |
The field 'Redundancy' must be activated.
The variable file SQLDRV.INI must be on the server and on the standby server. (to be specified separately for Remote Transport)
Especially when using Access databases, you have to make sure that the database path must be the same for both server and standby server. The same applies for the DNS file. (e.g.: path statement with computer names.)
In redundant operation, a data set will be deleted either if ACK_SRV and ACK_SB take on the value 1 or if the INSERTZEIT is older than 5 minutes.
