This article will guide you through the process of adding a new, advanced data source driver in the Windows ODBC Data Source Administrator. In this example, we will connect to a SQL database, but the steps will be similar for connecting to MySQL and other advanced databases.
Be sure to have the information about your data source available. This information can include the type of data source, the name of the source, and the username and password used to connect to the data source.
Please reach out to your IT person if you need any of this information or are unfamiliar with ODBC.
When connecting the Stamps.com software to an ODBC data source, you are given the option of connecting to an existing data source or to create a new one.
-
Select Create a new data source and then click Next.
-
Select Other/Advanced (SQL, etc.). Then, click Next.
The Windows ODBC Data Source Manager will open.
Connecting to Excel, TXT/CSV, Access
When connecting to Microsoft Excel, a TXT or CSV file, or to a Microsoft Access database, select the correct option and click Next. The wizard will guide you through the process of creating your data source.
-
Click the Add button.
-
Select the correct driver from the list and click Finish.
For this example, we have selected SQL Server.
-
Enter the following information. Then, click Next.
-
Name: The display name for your data source
-
Description: Optional description for your data source
-
Server: Select the SQL server from the drop-down menu
-
-
Select the correct authentication method for your connection. Enter the Login ID and Password when required. Then, click Next.
-
Select the correct database and configure the options specific to your data source. Click Next.
-
Configure the options specific to your data source. Then, click Finish.
In most cases, the default settings can be left on this screen.
-
We recommend testing the connection to ensure that all settings are correct for the data source.
-
Click OK on the successful test results screen.
Your data source driver has now been successfully added and can be selected when adding an ODBC data source to the Stamps.com software.