EDIT:
*************THIS PROJECT HAS BEEN ADDED TO EZ-AI******************


This has been updated to include the latest information about this tool.

EZ-DB is a utility that will allow ARC to store and retrieve data from a database. The current databases that are supported are MySQL and MSSQL. EZ-DB can be downloaded from this site.

EZ-DB Pre-Release

The location that you place the folder doesn't matter, as long as you can connect to your ARC application. Unzip the contents of the zip file (the EZ-DB folder) to any location that you would like to have as the applications home. I haven't tested yet to see if this can run on a different computer by using the EZBuilderIP setting in the config file.

CONFIGURING THE APPLICATION

The EZ-DB.exe.config file contains the configuration settings for this application. I have stored a copy of this file in the Backup folder for you, if you make a mistake and need to recover a working version.

This is the contents of this file. As you can see, you should be running .net 4.5. Going down the list under the <appSettings> section you will see the following

Code:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <startup>

        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

    </startup>

  <appSettings>

    <add key="Server" value="localhost"/>

    <add key="UserName" value="Robot"/>

    <add key="Password" value="3Z-R0b0t"/>

    <add key="Database" value="robot"/>

    <add key="DBServerType" value="MSSQL"/>

    <!--add key="DBServerType" value="MySQL"/-->

    <add key="TableName" value="Variables"/>

    <add key ="EZBuilderPort" value="6666"/>

    <add key ="EZBuilderIP" value="127.0.0.1"/>

  </appSettings>

</configuration>

#Starting variables for EZ-DB

$SqlReturn = ""

$SqlCommand = ""

Exec("C:\EZ-DB\EZ-DB.exe","$tempC Out Wall-E")

$SqlCommand = "SELECT AVG{CONVERT{INT,VariableValue}} FROM Variables WHERE VariableName = '$tempC' and RobotName = 'Wall-E' and DateEntered > CONVERT{VARCHAR{10},GETDATE{},101}"

EXEC("C:\EZ-DB\EZ-DB.exe", "$SqlCommand In Wall-E")