Connect to SQL Server Database
Configure Calibration Control to Connect to SQL Server
After creating the Calibration Control database on your SQL Server, follow these instructions to connect Calibration Control (our Calibration Management Software) to your SQL Server database.
Select Database Format
Start Calibration Control. When running Calibration Control for the first time, select MS SQL Server type of DB format.
Choose SQL Database
Ape Software hosts a Sample && Blank internet-based SQL Server database that you can connect to in trial mode, or anytime. (Refer to SQL Cloud-Hosting for more information.)
To connect to your SQL Server database, select the Custom DB option.
Entering SQL Credentials
Alternatively, you can use an existing Connection String. If you have a successful SQL connection from another machine with Calibration Control, go to the Utilities tab on ribbon menu and copy the Connection String. Copy/paste that into the Connection String field of this dialog to then quickly test connection.
In the SQL Server Connection dialog, the Remember (Login) box is automatically checkmarked to skip this step next time. If left unchecked, you will be required to verify your server authentication again.
If you are already in an open session of Calibration Control (connected to any database, regardless of format type), you can easily establish a new server connection within the software application just by clicking SQL Connect from the Utilities tab of the ribbon menu.
Test SQL Server Connections
Reset Configuration Settings
The database connection process creates a configuration file in the local Settings folder on each computer where the application is running. It's easy to reset if a mistake is made in the start-up "Choose Database Type" process. To fix it, delete the config file.
(a) You can do this by holding down your [CTRL] key at the same time as double-clicking on the application icon to start Calibration Control. (It may require two attempts.)
(b) Or you can manually navigate to where the config file resides, and delete it.
In the local Settings folder, rename or delete the general.config file, and then open Calibration Control. The Settings folder is located at this path on the computer:
C:\Users\Public\Documents\Ape Software\Calibration Control
Restart the Calibration Control software application, and the start-up options will appear so you can select your database type and then credentials, (i.e., SQL Server, or choose to browse to existing MS Access database).
Last Updated: 27 July 2022