Need ANSI driver 32-bit User DSN for Windows 10 system to connect to PostgreSQL 13

Need ANSI driver 32-bit User DSN for Windows 10 system to connect to PostgreSQL 13

2 answers

I was able to download the correct driver from https://www.postgresql.org/

The connection string provided in https://www.connectionstrings.com/postgresql-odbc-driver-psqlodbc/ (ex:Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;) won't work.

For VBA, the correct string is pretty much simpler:
"DSN=PostgreSQL35W;Uid=;Pwd="

And, prior to use this string, you need to install in Windows the PostgreSQL ODBC driver (from https://www.postgresql.org/ftp/odbc/versions/msi/ ) and configure locally in Windows the ODBC (by typing "ODBC Data Sources" in Windows and choosing the right OS version - 32 or 64bits, then in "SYSTEM DSN" adding the PostgreSQL driver you've just installed -> note you'll need to specify in the DSN the same Name for the System Data Source, in my example it was PostgreSQL35W)

Best regards,

Eduardo.