SQL*XL can connect to different database types. SQL*XL connections to databases have to be configured only once. As soon as a connection is established you can pick it from the Connection History list on the Connection dialog.

Detailed information is available for the following databases:

• Access
  • using JET
  • using ODBC
  • using ACE OLE DB  
• Active Directory using OLE DB
• Advantage
  • using OLE DB
  • using ODBC
• Cache - Intersystems, through ODBC
• IBM DB2
  • using OLE DB
  • using ODBC
• dBase through ODBC
• Indexing Service through OLE DB
• MS Excel through ODBC
• Firebird through ODBC
• MS Project through OLE DB
• MS Visual Foxpro Databases through ODBC
• MS Visual Foxpro Tables through ODBC
• MySQL through ODBC
• Oracle
  • using OO4O
  • using OLE DB
  • using ODBC
  • using the Oracle Instant Client (IC)
• Paradox through ODBC
• Pervasive
• using OLE DB
• using ODBC
• PostgreSQL
  • using OLE DB
  • using ODBC
• QuickBooks through QODBC
• SQL Anywhere (Sybase Adaptive Server Anywhere) through ODBC
• SQL Server
  • using OLE DB
  • using ODBC
• Text files through ODBC
• XML files through OLE DB

If your database and driver is not in the list please read the general information below.

All connections are made by opening the Connection dialog.

To make a new database connection, press the new connection button in this dialog.

It's not as complicated as it sounds. Look at the Datalink Properties Wizard help first. Detailed information is given for the most common databases and drivers. If you want to connect through ODBC have a look at the Data Source Administrator window topic as well.

See also:

• Connection dialog
• ODBC Data Source Administrator
• Data Link Properties wizard