If you need help in entering an ADO connection string, click the Build button, which opens the ADO Data Link properties dialog box.
ADO Data Link properties dialog box:
Select the corresponding OLE DB Provider from the list and click on the Next button to enter the connection properties:
XML Spy relies on the ActiveX Data Object (ADO) interface for much of the basic database connectivity. ADO is included with Windows 2000 and Microsoft Office 2000, but you may need to install it if you are using an older version of Windows or Office.
Activate the "Allow saving password" check box, to enter your password info into the connection string, and avoid an error message when the connection takes place.
Please refer to our FAQ for more information on ADO and to download the Microsoft Data Access Components (MDAC) which allow you to upgrade to the latest ADO version. We also recommend that you visit the Microsoft Universal Data Access site on the Internet.
After you have imported your data and converted it to XML format, you may also want to use the Generate DTD/Schema function to get all the datatype information you need from your database into your XML documents.
XML Spy now makes it possible for you to convert a database into a schema. MS Access and several other databases are able to automatically provide the key and keyref information for the ADO driver, used to create the database hierarchy.
Please see the section under the Convert menu | Create Database Schemafor more information.
