Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Advanced Connection Properties

SQL Server 2000

Advanced Connection Properties

Use this dialog box to set custom values for certain OLE DB initialization properties. The OLE DB advanced properties available for customization varies depending on the properties supported by a particular provider. For more information, see the programming documentation for the individual OLE DB provider.

To change an OLE DB property value, in Value, click a cell, and then enter the new value.

Note  If you need to work more closely at the OLE DB level, the OLE DB Rowset Viewer, available with the OLE DB Software Development Kit (SDK), offers a simple way to view and manipulate OLE DB rowsets. It also gives you the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider.

See Also

DTS Connections

© 2015 Microsoft