To access a SQL Server via scripts, use an ADODB connection. A connection String for this type of database is defined according to the next template.

DRIVER={SQL Server};SERVER=server;UID=login_id;PWD=password;

Using this type of access must be restricted to cases when there is no other solution. Elipse E3 provides features that aim at minimizing database access via script. However, on some circumstances this feature may be necessary.