| Application bitness | How to open ODBC Administrator | |---------------------|--------------------------------| | 64-bit | C:\Windows\System32\odbcad32.exe | | 32-bit | C:\Windows\SysWOW64\odbcad32.exe |
| Field | Description | |-------|-------------| | | A friendly name (e.g., MyPostgreSQLDB ) | | Database | The name of your PostgreSQL database | | Server | IP or hostname (e.g., localhost or 192.168.1.10 ) | | Port | Default is 5432 | | User Name | Your PostgreSQL user (e.g., postgres ) | | Password | The user’s password | how to install postgresql odbc driver on windows
A DSN stores connection settings for easy use. | Application bitness | How to open ODBC