Hello
I used the ODBC Postgresql driver to connect to my database in Excel on Mac.
The problem I have is that the accent do not appear properly
For instance, "José" appears as "Jos√©"
What should I change to get accent properly?
Search found 2 matches
- Tue 12 Oct 2021 14:31
- Forum: ODBC Drivers
- Topic: Problem with accent in ODBC Postgresql in Excel
- Replies: 1
- Views: 13691
- Tue 12 Oct 2021 14:29
- Forum: ODBC Drivers
- Topic: Password visible in Connection string ODBC PostgreSQL
- Replies: 1
- Views: 14061
Password visible in Connection string ODBC PostgreSQL
Hello
I am using the ODBC Driver for PostgreSQL in Excel on Mac.
I configured the System DSN and it worked.
I then created a new database connection in Excel using the ODBC.
After triggering it for the first time, I got a pop-up asking for the login and password to the database.
I added them but then I realized that they had been added to the connection string.
The login and password to our database is visible there and accessible to anyone who would get the excel file.
How could I change this?
I am using the ODBC Driver for PostgreSQL in Excel on Mac.
I configured the System DSN and it worked.
I then created a new database connection in Excel using the ODBC.
After triggering it for the first time, I got a pop-up asking for the login and password to the database.
I added them but then I realized that they had been added to the connection string.
The login and password to our database is visible there and accessible to anyone who would get the excel file.
How could I change this?