Thread: ODBC connections
I’m setting up an ODBC connection from server A to server B. When I click test, I get an error, screen shot below.
Using PostGre SQL 9.5, ODBC driver was 9.5.210 x64. I believe I Need to edit the postgresql.conf file to include the tcpip connections, but I’m not finding the exact syntax to use. It looks like I need to have –i somewhere in the conf file?
Cindy Taylor | MOSS ADAMS LLP
Database Administrator
999 Third Avenue, Suite 3300
Seattle, WA 98104
D (206) 302-6350 | C (425) 213-4633
CONFIDENTIALITY NOTICE
This e-mail and any attachments are for the sole use of the intended recipients and contain information that may be confidential or legally privileged. If you have received this e-mail in error, please notify the sender by reply e-mail and delete the message. Any disclosure, copying, distribution, or use of this communication by someone other than the intended recipient is prohibited.
Attachment
On 05/26/2016 04:42 PM, Cindy Taylor wrote: > I’m setting up an ODBC connection from server A to server B. When I > click test, I get an error, screen shot below. > > > > Using PostGre SQL 9.5, ODBC driver was 9.5.210 x64. I believe I Need to > edit the postgresql.conf file to include the tcpip connections, but I’m > not finding the exact syntax to use. It looks like I need to have –i > somewhere in the conf file? https://www.postgresql.org/docs/9.5/static/runtime-config-connection.html " listen_addresses (string) Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications. The value takes the form of a comma-separated list of host names and/or numeric IP addresses. The special entry * corresponds to all available IP interfaces. The entry 0.0.0.0 allows listening for all IPv4 addresses and :: allows listening for all IPv6 addresses. If the list is empty, the server does not listen on any IP interface at all, in which case only Unix-domain sockets can be used to connect to it. The default value is localhost, which allows only local TCP/IP "loopback" connections to be made. While client authentication (Chapter 19) allows fine-grained control over who can access the server, listen_addresses controls which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces. This parameter can only be set at server start." You might also want to check that any firewall between server A and B has port 5432 open. > > > > > > *Cindy Taylor | MOSS ADAMS LLP** > *Database Administrator > > 999 Third Avenue, Suite 3300 > Seattle, WA 98104 > *D****(206)**302-6350 *| *C****(425)**213-4633* > > > > ** > *CONFIDENTIALITY NOTICE > *This e-mail and any attachments are for the sole use of the intended > recipients and contain information that may be confidential or legally > privileged. If you have received this e-mail in error, please notify the > sender by reply e-mail and delete the message. Any disclosure, copying, > distribution, or use of this communication by someone other than the > intended recipient is prohibited. > > > -- Adrian Klaver adrian.klaver@aklaver.com