WinTr operates SQL server functions. First of these is historical Tag data for the charts. Furthermore uses SQL functions for accessing other programs and Internet. This section is for managing this operations.

       WinTr creates a server named WinTr on your computer and makes all operations at this server. Other programs should use this server in order to connect to WinTr. Even SQL Server 2005 installed  on your computer if WinTr named SQL Server instance does not exist WinTr tries to connect it when it starts. If WinTr can not find it prompts for installing. Without this huge part of program does not work. The password for SQL Server determined by Wintr is User: sa Password: 12341234

       When you create a new project WinTr generates a message that indicates you need to save the project before all. While first saving of project or at each save as operation WinTr creates a Database that has similar name with the project. If that database exist changes the name a bit and creates distinct database for this project. Many project with the same name can exist on your computer. But more than one database can’t exist with the same name.

Server Name: You need to enter server name to connect here.(COMPUTER NAME\SQL SERVER NAME For example WinTr installs SQL Server with “WINTR” instance name.

When connecting on Internet address sould be at this format: IP NUMBER\SQL SERVER NAME, TCP PORT NUMBER

Example: “100.0.0.4\SQLEXPRESS,1410”

Password: Default password is 12341234 for the sql connection. At First it useless. There is two authentication type for SQL server 2005 database access. Windows authentication and password verification. Windows authentication can be used only if desired but only password verification can not be used. When you select this two method selected.  All security settings made form Windows and SQL server. If you want password verification you need to enter the password here.

The password entered here is the Server password not database password.

Database Listing: Transfers database list and properties to the table.

Select Database: Select a database you want to use. If list is empty create by clicking Create New Database button.

Table Row Count: The line number inside the SQL server.

Max.Row Count: WinTr uses free licensed version of SQL server. This is the 4 gb database size limited version. Enter here maximum line number by calculating data sizes you associated to SQL server . Or without calculation make selection according desired historical datas. WinTr saves a record approximately at each second. Hence the value you entered here actually is a time. WinTr controls this line number at each startup. If data line number exceeded this number generates a message for deleting %20 of the records from the bottom. You can delay this by answering no. Everytime switching to runtime this warning will produced. When you answered as yes automaticaly deleted.

Clear Database: You may create many unnecessary data while developing a project. You can erase old datas with this button when your project finished.

Note: After you associated datas with the SQL server if this relation modified WinTr will warn you and want you to make SQL Tag building operation. When you do this it will add new Tags to the SQL and delete the unused ones. The value type changed Tags first deleted then recreated. Thus you will use some old data. So SQL Tag Building not operated automaticaly. You may want not to lose that datas. You need to do this manualy when you desired.

SQL Server Recording Time: Runtime refreshes approximately each second. Minimum refresh period is 800 ms. Sometimes we want to collect datas quickly even we don’t watch them real time. For Example: We may want to reach detailed datas of fast events. In such situation we collect more data by decreasing this value.

Check Tag Configuration: Pairs the historical tags that created in Connection manager and database table. If it is not made generates a message to starting “SQL Tag Building” operation. Pairs SQL Table and Tag list with this operation. Erases SQL records of tags that previously used but not reside at tag list.    Creates new columns at database table for previously not used but new added tags.