This section includes examples for connecting to a database from XMLSpy through ADO, ODBC, or JDBC. The ADO.NET connection examples are listed separately, see Sample ADO.NET Connection Strings. For instructions about establishing a native connection to PostgreSQL and SQLite, see Setting up a PostgreSQL Connection and Setting up a SQLite Connection, respectively.
Note the following:
•The instructions may differ if your Windows configuration, network environment and the database client or server software are not the same as the ones described in each example.
•For most database types, it is possible to connect using more than one data access technology (ADO, ADO.NET, ODBC, JDBC) or driver. The performance of the database connection, as well as its features and limitations will depend on the selected driver, database client software (if applicable), and any additional connectivity parameters that you may have configured outside XMLSpy.