Connect to Your Cosptoint Database

After the ODBC driver is installed and configured, you can make a connection between the workstation and the Costpoint database, using any application that supports ODBC connectivity.

This procedure uses Microsoft Excel as an example application. The process for other applications may not be exactly the same, but will be very similar.

To connect to the Costpoint database:

  1. Go to the application from which you want to connect to the Costpoint database and initiate an ODBC connection.

  2. Select the data source that you entered in the Data Source field in Step 6 above.

    image001

  3. Enter your credentials for the database connection.
  4. Build a query.

    image006

  5. Execute the query.

    C:\Users\brettushaus\Dropbox\Images\2-11-2015 5-15-20 PM.jpg

Parent Topic: ODBC Access to the Costpoint Database