4.7.10. Changing ODBC connection parameters at regular interval

<< Click to Display Table of Contents >>

Navigation:  4. How to use Anatella? > 4.7. Batch Execution / Anatella command-line >

4.7.10. Changing ODBC connection parameters at regular interval

 

There are two ways to change the ODBC connection parameters at regular interval:

 

1.You can use the “Global Parameters” to define the ODBC connection parameters.
Here are two examples:

oFor a Type-1 ODBC connection:

Open the “ODBC properties” windows: i.e. Click here:

 

ANATEL~1_img214

 

 

 

 

Inside the “ODBC properties” windows, use the “>” character to specify “Global Parameters”: For example, this is valid:

 

 

ANATEL~1_img216

 

 

oFor a Type-2 ODBC connection:
 

Right-click the ODBC connection string to edit it directly:

ANATEL~1_img217

 

Then, use the “>” character to specify “Global Parameters”: For example, this is valid:

 

 
> "DRIVER=SQL Server;SERVER=192.168.59.130;UID="+GP_ODBC_Login+";PWD="+GP_ODBC_Password+";Trusted_Connection=No;DATABASE=TIMi"
 

 

 
Hereabove we used some “Global Parameters” to define the ODBC connection parameters. Now, we need to update these “Global Parameters” to the right values, each time that the ODBC connection parameters are changed: You can do that in different ways:
 

o…using the command-line arguments: See section 4.7.1.
 

o… using this simple Action:
 

ANATEL~1_img218

 

o… using these two Actions (this must be the first two actions executed in the graph):

 

ANATEL~1_img219

 

o…using these three Actions (this must be the first three actions executed in the graph):

 

    ANATEL~1_img220

 

o… using these two Actions (this must be the first two actions executed in the graph): This is deprecated:

 

            ANATEL~1_img221

 

 

2.You can use the Javascript Object named “AnatellaGraph” to update “in bulk” all the parameters (including the ODBC connection parameters) inside all your graphs: For example:

 

clip0011