TABLE 1: Sample Options for the Data Connection Statement
OptionDescription
Integrated Security=SSPI Use NT integrated security
Persist Security Info=False Do not persist security information
Initial Catalog=Northwind Database name
Data Source=KLSTOSHIBA Server name
User Id=kls User ID
Description=websql1 Description of the data source
SERVER=klstoshiba Server name
UID=kls User ID
WSID=KLSTOSHIBA Workstation ID
DATABASE=Northwind Database name (same as Initial Catalog property)
Trusted_Connection=Yes Use NT integrated security (same as Integrated Security property)