OLE-DB data connection properties

Catalog

The name of the database to which the item connects. Only required for SQL Server.

Any valid database name.

DataSource

The Server name, Schema name, or File name as appropriate to the type of database to which the item connects.

For SQL Server: <Server Name>. For Oracle: <Schema Name>. For Access: <File Name>

IntegratedSecurity

Whether the item uses SSPI. Only required for SQL Server.

If the data connection does not use integrated security, leave this property blank so that AVEVA™ Production Management uses the Password and UserID properties; for example, when you connect to a remote SQL Server.

If the data connection uses integrated security, type SSPI as the property value so that AVEVA Production Management ignores the Password and UserID properties and uses the Windows logon details of the current user.

Blank or SSPI

Password

The password that the item uses to log on to the database. The item uses this property when the IntegratedSecurity property is blank.

Any valid password

Provider

The name of the OLE DB driver that the item uses.

Any valid OLE DB driver name. Examples: For SQL Server “SQLOLEDB”. For Oracle “ORAOLEDB” For Access “Microsoft.Jet.OLEDB.4.0”

UserID

The user name that the item uses to log on to the database. The item uses this property when the IntegratedSecurity property is blank.

Any valid user name