Connect to Database
This Automation Manager object connects to an SQL Server database.
Input Parameters
| Use Local |
Boolean |
Yes |
Determines if a local instance of SQL server is to be used. |
| Server |
String |
No |
Name of the server, this should be blank for the local server. |
| Database |
String |
Yes |
The name of SQL instance, use (local) for local unnamed instance. |
| Type |
String |
No |
TCP or Named Pipes. |
| Pipe |
String |
No |
|
| Use SQL Authentication |
Boolean |
No |
Determines whether or not to use SQL Authentication rather than
Windows authentication.
|
| User Name |
String |
No |
Used for SQL Authentication, not required for windows credentials. |
| Password |
String |
No |
The password for SQL Authentication, not used for windows credentials. |
Output Parameters
| Result |
Number |
Returns a success value of zero or any value other than zero to indicate failure. |
Example Input Parameters
| Use Local |
Boolean |
Yes |
Select this option to connect to the local server. |
| Server |
String |
No |
<intentionally left blank> |
| Database |
String |
Yes |
SQLdev |
| Type |
String |
No |
TCP |
| Pipe |
String |
No |
<intentionally left blank> |
| Use SQL Authentication |
Boolean |
No |
Select this option to use SQL authentication. |
| User Name |
String |
No |
<intentionally left blank> |
| Password |
String |
No |
<intentionally left blank> |
