<< Click to Display Table of Contents >>
Using ADODB to Access a SQL Server via Script |
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 Power provides features that aim at minimizing database access via script. However, on some circumstances this feature may be necessary.