Show AllCheck your driver First, make sure you have the right ODBC driver or data source driver for your data source. ODBC drivers and data source drivers make Microsoft Query flexible so that you can connect to new databases as they become available by installing new drivers. However, you must make sure you install and set up the right driver for the type of database you're using.
Make sure the driver works with Microsoft Query In addition to the drivers provided with Microsoft Query, you can use ODBC and data source drivers provided by third-party manufacturers. Before you try to use a third-party driver, it's a good idea to make sure the manufacturer has tested the driver with your version of Microsoft Query. For some databases, the driver supplied with the database software may be the best choice. Contact the administrator for your database to find out what's available and what works best at your site. See a list of the drivers supplied with Query.
Check the server address and logon information Before you set up a data source, make sure you know the address where the database is located on your network and have the necessary permissions to connect to the database and log on. See the administrator for your database for a logon name, password, or any other permissions required, and to make sure the access you've been granted is working properly.
Make sure the driver is properly installed To display the list of available ODBC drivers, click New Query
, double-click New Data Source on the Databases or OLAP Cubes tab, type a name in step 1 of the Create New Data Source dialog box, and then click the list in step 2. If the OLAP Cubes tab is not available, run Query from Microsoft Excel by pointing to Get External Data on the Excel Data menu, and then clicking New Database Query. Double-click New Data Source on the OLAP Cubes tab, type a name in step 1 of the Create New Data Source dialog box, and then click the list in step 2. If you don't see the driver you need, you should check to make sure the driver is installed properly. How to install drivers.
Make sure you supplied all of the configuration information After you've installed the driver and selected it in step 2 of the Create New Data Source dialog box, make sure you provide all of the necessary information in step 3 of the dialog box. For information about a Microsoft driver, click Connect, and then click Help in the setup dialog box for the driver. For third-party drivers, see the Help system or the documentation for the driver.
If you are setting up a data source with an ODBC driver or data source driver provided by Microsoft, click the name of your driver for information about the settings you should make in step 3 of the Create New Data Source dialog box.
Note Query cannot access data sources created with the Data Connection Wizard.
Microsoft Visual FoxPro driver
Microsoft ODBC for Oracle driver