Using FedEx Ship Manager with an SQL Data File

This article outlines the steps necessary to set up the integration between the Enterprise Edition of the Order Manager (SQL data file) and FedEx Ship Manager.

If you are running the Enterprise Edition of Order Manager with an MS Access data file, do not follow the instructions in this article. Instead, refer to the article Setting Up and Using FedEx Ship Manager.

This article assumes that the Enterprise Edition of the Order Manager is already up and running, i.e., the Order Manager database (store) file is installed successfully on a SQL server and the Order Manager program file has been installed on the computer where you wish to setup Ship Manager.

 

For troubleshooting tips, see the Troubleshooting section below.

 

Link FedEx Ship Manager with the Order Manager

    1. Create a blank Access database. Name it "Worldship.mdb" or something similar, and if possible, save it in your StoneEdge directory (e.g. C:\StoneEdge).

Note1: Order Manager uses the same internal processes (Worldship queries) to work with UPS Worldship and FedEx Ship Manager, hence the references to Worldship in this article are not errors.

    1. Open the Access database. From the File drop-down menu, select Get External Data> Link Tables. The Link window opens.

Note2: This article shows screen shots of an MS Access 2003 installation. If you are using Access 2007, the forms will look different but the same functionality is available.

image473.jpg

    1. At the bottom of the Link window, click the Files of type drop-down list and select ODBC Databases. The Select  Data Sources window opens.

image474.jpg

 

    1. Under the Machine Data Sources tab, select the Order Manager database (store) file System DSN (this was created when you set up the OM Enterprise and points to your OM database on SQL server.) click OK. The Link Tables window opens.

image458.jpg

 

    1. Holding the Ctrl or Shift button, select your orders table, typically "dbo.Orders," and dbo.ShippingMethods from the list of tables. Click OK.

    2. The database dialog box opens:

image461.jpg

 

    1. From the File drop-down menu, select Get External Data> Import. The Import window opens.

image472.jpg

 

    1. Browse to your Order Manger files (typically located in C:\StoneEdge) and select the SEOrdManEnt2002.mdb file. Click Import. The Import Objects window opens.

image462.jpg

 

    1. On the Queries tab, select WorldShipOrdersSQL. Click OK. The files now shows up in your Queries list.

image463.jpg

 

    1. Now, create a new System DSN for this Access database. Go to Control Panel> Administrative Tools> Data Sources. The ODBC Data Source Administrator window opens. On the System DSN tab click Add.

image467.jpg

 

    1. The Create New Data Source window opens. Click Microsoft Access Driver (*.mdb) and click Finish.

image466.jpg

 

    1. Type a name (any name will do) for the DSN in the Data Source Name field, and then click the Select button.

image471.jpg

 

  1. The Select Database window opens. Select the location of the new database you created in Step 1 (e.g. "worldship.mdb") and click OK.

image469.jpg

 

  1. Click OK in the ODBC Microsoft Access window. The DSN name will now appear in your ODBC Data Source Administrator window.

Next Steps
To finish setting up the integration between FedEx Ship Manager and the Order Manager, return to Setting Up and Using FedEx Ship Manager and complete steps 6-19.

 

Troubleshooting

ODBC errors may occur if the SQL Server is not configured properly. Creating a trusted connection between the server and the computers running FedEx Ship Manager may resolve some of the errors. For further assistance, contact Stone Edge Technologies Tech Support.

 

Created 6/2/09

Modified 4/29/10