Description

You are facing SQL error messages and require to test SQL connectivity.

Applies To

Foundation 11.x and 12.x

Cause

SQL connection test

Solution/Immediate Workaround

You can test a data provider’s connection string (like a SQL Server database) with the help of a plain text file using Notepad.
To investigate and test out if your connection string works, you’re going to want to create a UDL file.

To do this, follow these steps:
1. Open up Notepad and create an empty text file, then click File -> click Save -> and save it with the File name: TestConnection.udl to your desktop.
2. Go to your desktop and double-click on the TestConnection.udl file you just created and the Data Link Properties box will popup.
3. Select the Provider tab and Find the provider that you want to connect with and click Next >>
4. Now from the Connection tab, select or enter your source/ server name  then enter information to log on to server -> and select the database on the server.
5. Click Test Connection and click OK to save the file.

Note: If errors occur during testing of your connection string, you will get a popup box with the error message

Open an empty notepad:

Save as an example: testdb

Save as type: All Files --> Encoding: ANSI -->

Additional Information