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 ...
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 ...
Setting up a Connection to Power BI Online Using Devart ODBC Driver
In this guide, we will walk you through the process of setting up a connection to Power BI Online using the Devart ODBC Driver. This involves creating a DSN connection, setting up an on-premises gateway, and verifying Power BI report settings. Step ...