Installing ODBC Drivers

Installing ODBC Drivers

1. Download client32.zip.
2. Unzip client32.zip into a folder. Run Setup.exe from the folder.

3. Click Next or Yes on the screen until you get to the Interbase component selection screen. Here you need to uncheck all options except for the last option: OBDC driver.

4. The destination folder should be the Interbase folder you already have set up in Quantum. This is usually either c:\quantum\interbase or c:\program files\interbase corporation\interbase. Click Install.
5. When a message appears saying that the installation was successful, click Finish.
6. Go to Start -> Settings -> Control Panel. Open Administrative Tools.

7. Open Data Sources (ODBC).

8. In the ODBC Data Source Administrator window, click the User DSN tab, and the click Add... to create a new data source.

9. Select INTERSOLV InterBase ODBC Driver (*.gdb) from the list and click Finish.

10. In the ODBC InterBase Driver Setup screen, click the General tab. Then enter the name for your data source. This should be something like "Quantum Database", or some other descriptive name for the connection. In the Database Name field, enter the complete path to the Quantum database. This should include server IP address, the path on the server and the file name with extension. Use the form: IPaddress:drive:\path\quantum.gdb.

11. Click OK. This data source should now appear in the User Data Sources section of the ODBC Data Source Administrator. Click OK to close this window.

To use with Microsoft Excel (97, 2000, XP):

Note: you might need the Excel or MS Office CD to perform these operations. If at any point during this time you are prompted to install from the CD, insert the CD and follow on screen instructions. Please refer to Excel documentation for more information.

The following steps should be performed only on a machine that has ODBC drivers installed (see steps 1-11 above).

1. Start Excel. Go to the Data drop down menu and select Get External Data. Then select New Database Query.

2. Select the Data Source you created above and click OK.

3. Enter your user name and password and click OK.

4. When the Query Wizard window appears, you are connected to the Quantum database. At this point you may select tables and/or fields to include in your query. Please refer to the Quantum data dictionary for information regarding the tables and to MS Query documentation for assistance with using Query.