Skip Navigation Linkssite home | calibration control | help | sql connection

Troubleshoot SQL Server Connection

for Use with Ape Software Databases

WARNING:  Ape Software applications can only connect to databases created by and specifically for the given Ape Software application.  Blank databases, databases created by non-Ape professionals, and modified Ape Software databases will not connect or not connect properly.  Also, SQL Server databases created by migrating an existing MS Access database will also not work and often have severe functional issues sometimes not immediately visible.

Universal Data Link (UDL) File

Use a UDL file to create a direct connection to a SQL Server database with as few other variables as possible, like connecting through other software.  This helps to simplify and focus the troubleshooting process on the most likely failure points (e.g., SQL Server configuration or network permissions).

A UDL file is simply a text file with a .udl extension.  Therefore, creating a UDL file is as simple as creating a new text file and changing its extension to UDL.

Create a UDL File

Create a UDL file by (1) right-clicking in a folder or desktop, (2) selecting 'New', (3) selecting 'Text Document', and then (4) creating a text file with a .udl extension (e.g., MyTestFile.udl).

Create a Text File

Note:  If a warning appears related to making the file unusable by changing its extensions, ignore the warning.

Data Link Properties

Double-click on the new UDL file and the following Data Linke Properties dialog appears.

Provider Tab

Select the appropriate SQL Server Provider.

Data Link Properties

Connection

In the Connection tab . . .

  1. Enter the fully qualified SQL Server name.
  2. Select the authentication method (i.e., Windows or {1st choice} or SQL Server {2nd choice} and enter the appropriate user name and password, if SQL authentication is used.
  3. Select the database.  By default, this is apecal but must match whatever name is actually used on the SQL Server.
  4. Click the [Test Connection] button.
Data Link Properties

If the above test fails, then work with your organization's Database Administrator (DBA) to resolve the connection before attempting to use the Ape Software application.  If using SQL Server authentication, the User Security section of the Add Ape Database to SQL Server help topic is often useful.

Test Connection Succeeded

Otherwise, if the above process leads to a 'Test connection succeeded' dialog and the Ape Software application cannot connect to the SQL Server, contact Ape Software to continue troubleshooting the connection.


Last updated:  3 Jan 2017

Compatibility:  Calibration Control versions 7.4.5 to current

Download Calibration Control

Email: *

Name: *

Company: *

Day Phone:


Security Permissions
Thermal Transfer Label Printer
Calibration Edit Dialog
Status Change Utility
Calibration Scatter Plot
Grid Features
USB Barcode Scanner
Calibration Event Structure
Edit Equipment Dialog
Asset Transfer Utility