When proceeding with a Connection Test from the “PostgreSQL Unicode ODBC Driver (psqlODBC) Setup” windows, a warning may be displayed.  If the warning displayed is similar to the following…


FATAL: no pg_hba.conf entry for host

“xxx:xxxx”, user “postgres”, database

“xxx”,SSL off


... there are custom lines that can be added to your pg_hba.conf file on the server which may resolve the issue.


The standard default path location of this file is:


C:\ProgramData\Spire\PostgreSQL\10\pg_hba.conf


The lines to be added are as follows (these are example lines based on the most common problem and solution):


host all postgres fe80::/64 md5
host all postgres samenet md5


Note that "postgres" here refers to the account you are using in your ODBC connection.  If you used "spireapp" then specify "spireapp" here instead.  You can specify "all" here for any account to work, or "+spireuser" for any user tied to that group.


* Please restart all Spire related services after these changes are made


* It may be required that you have an inbound firewall rule for TCP port 5432.  If that rule is not present please consider adding it.


If you wish to research other IPv6/IPv4 solutions, especially if you have a more specific error message, please feel free to navigate to the following link:

https://www.postgresql.org/docs/10/auth-pg-hba-conf.html