You are here: Setup Guide > Set Up Data Sources > Connect to Visual FoxPro

Connect to Visual FoxPro

This topic describes how to create a new OLE-DB data source to connect to a Visual FoxPro or dBase II for use with Endicia Professional.

The first time you run Endicia Professional, the Database Connections Setup wizard starts automatically.

Afterward, you can manually start the Data Connections Setup wizard.

Steps

  1. For a new OLE-DB connection, select Create a new data source (using OLE-DB), and click Next.
  2. In the Data Provider field, select Visual Fox Pro, and click Next.
  3. Click the Browse button and locate your Visual FoxPro (dbf) database file.
  4. Click Open.

    The path and file name appear in the Location area of the Create Data Source dialog box.

  5. Only in special circumstances, such as under the directions of technical support, select the Show the database connection string check box.
  6. Otherwise, do not select the check box.

  7. Click Next.
  8. If you selected the Show the database connection string check box, the wizard panel displays the connection string. You should NOT edit the connection string except in special circumstances and when instructed by technical support.

  9. If technical support instructed you to change the connection string, enter those changes.
  10. Click Next.
  11. Enter a name of your choice for the data source name, and click Next.
  12. Click OK to finish the wizard. The Order Lookup Data Map window displays your data source name.

After you have specified the OLE-DB data source to use with Endicia Professional, the Create a SELECT Statement wizard runs that helps you specify the SELECT statement to retrieve data from your Visual FoxPro data source file.

 


 

Image of Endicia Logo

Copyright © 2017 Endicia. All Rights Reserved.