Hi @sush_1 , can you please follow the below steps and verify if the test connection works
To manually configure an ODBC DSN (Data Source Name), you can follow these general steps:
Open the ODBC Data Source Administrator:
In Windows, you can typically find it in the Control Panel under Administrative Tools or by searching for "ODBC" in the Start menu.
Navigate to the System DSN or User DSN tab: The System DSN tab configures a DSN that is available to all users on the computer, while the User DSN tab configures a DSN specific to the current user.
Click the "Add" button: This will open a dialog to create a new DSN.
Select the appropriate driver: Choose the driver that matches the database or data source you want to connect to. The available drivers depend on the software and database drivers installed on your system. For example, if you want to connect to a Microsoft SQL Server database, you would select the appropriate SQL Server driver.
Provide the necessary information: The exact information required may vary depending on the selected driver, but typically includes the DSN name, a description (optional), the server or database name, authentication details (username and password), and any additional connection parameters or options.
Test the connection: After providing the required information, you can use the "Test" or "Test Connection" button to verify that the connection to the data source is successful. This step helps ensure that the configuration is correct and the necessary drivers are installed.
Save the DSN: Once you have tested the connection and verified its success, save the DSN configuration.
After configuring the DSN, you can use it in applications that support ODBC to connect to the specified data source using the configured settings.
.png){kind=link}