Note: Use Unicode unless you have a specific reason to use ANSI. 3. Enter Connection Details A setup window will appear. Fill in the following:
A name you choose (e.g., "Postgres_Production"). Database: The name of your database. Server: Your server IP or "localhost". User Name & Password: Your database credentials. Port: Default is 5432 . 4. Test the Connection
The official repository is the only place you should download the driver to ensure security and compatibility. Visit the psqlODBC download page download postgres odbc driver
Click the tab (this makes it available for all users). Click Add . Select PostgreSQL ANSI or PostgreSQL Unicode .
Search for "ODBC Data Sources" in your Windows Start menu. Choose the version (64-bit or 32-bit) that matches your application. 2. Add a New Data Source Note: Use Unicode unless you have a specific
Click the button. If you see "Connection successful," you are ready to go. ❓ Troubleshooting Common Issues
Generally, you should download the latest version (e.g., 16.00 or higher). Fill in the following: A name you choose (e
Check your PostgreSQL pg_hba.conf file to ensure remote connections are allowed.