Altova XMLSpy 2024 Professional Edition

Setting up the SQL Server Data Link Properties

Home Prev Top Next

When you connect to a Microsoft SQL Server database through ADO, you may need to set the following connection properties in the All tab of the Data Link Properties dialog box.

ADOConnectionDialog05

Data Link Properties dialog box

Property

Notes

Integrated Security

If you selected the SQL Server Native Client data provider on the Provider tab, set this property to a space character.

Persist Security Info

Set this property to True.

© 2017-2023 Altova GmbH