Password visible in Connection string ODBC PostgreSQL

Password visible in Connection string ODBC PostgreSQL

When connecting to a PostgreSQL database using ODBC, you may encounter a situation where the password is visible in the connection string in Microsoft Excel. Unfortunately, we do not have the ability to alter how Excel handles or displays this information.

If you do not want other users to see the password in the connection string, you should avoid saving it within the DSN. Instead, consider entering it manually every time you establish a connection.

    • Related Articles

    • Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver

      This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...

    • Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver

      This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...

    • Error 193 While Creating ODBC Connection in ODBC Administration

      If you encounter Error 193 while creating an ODBC connection, it's important to note that our ODBC drivers currently do not support Windows ARM. We are actively working on expanding compatibility and will provide updates on the possibility of ...

    • Using SSL with dotConnect for PostgreSQL from NuGet

      When using dotConnect for PostgreSQL via NuGet packages, note that SSL support is not included in the NuGet assemblies by default. To enable SSL connections, you must manually add the necessary assemblies from the full Devart installation package to ...

    • Guide: Configuring ODBC Driver in Azure Data Factory

      This guide walks you through the steps of setting up and using an ODBC driver in Azure Data Factory (ADF) for seamless data integration. By following this guide, you will be able to configure an ODBC driver, create a Linked Service, and define an ...