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

    • TLS 1.3 Support on Windows 10 with MySQL and PostgreSQL

      Issue When connecting to MySQL or PostgreSQL servers on Windows 10, you may encounter errors if the server is configured to use only TLS 1.3. However, the connection succeeds if TLS 1.2 and TLS 1.3 are both enabled. Reason Windows 10 does not support ...

    • [Devart][ODBC][Quickbooks Desktop] Could not start Quickbooks

      I am attempting to evaluate the Quickbooks Desktop ODBC Driver. When I set up the ODBC data source, link it to the company file and then click "Test Connection" I get the following error message: "[Devart][ODBC][Quickbooks Desktop] Could not start ...

    • error 193 while creating odbc connect in ODBC Administration

      error 193 while creating odbc Please note that our ODBC Drivers do not currently support Windows ARM. We will investigate the possibility of using our products on the Windows ARM operating system.

    • How to configure Devart ODBC drivers for optimal performance?

      To optimize Devart ODBC drivers, consider configuring parameters that influence the connection timeout, data fetching size, and logging level. Adjust settings based on the database you are using, especially for cloud connections like Salesforce or ...

    • Can I use the odbc driver in Power BI Online?

      However, I am encountering an issue with data updating in the cloud via Power BI Gateway. Despite the smooth operation in Power BI Desktop, the data does not seem to update as expected when using the cloud service. Do you have any documentation or ...