Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 02A71F497B9 for ; Mon, 27 Feb 2012 10:17:30 -0400 (AST) Received: from mail-pw0-f46.google.com ([209.85.160.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S21OJ-0006Fp-QY for pgsql-sql@postgresql.org; Mon, 27 Feb 2012 14:17:29 +0000 Received: by pbcup15 with SMTP id up15so2103618pbc.19 for ; Mon, 27 Feb 2012 06:17:14 -0800 (PST) Received-SPF: pass (google.com: domain of adrian.klaver@gmail.com designates 10.68.221.73 as permitted sender) client-ip=10.68.221.73; Authentication-Results: mr.google.com; spf=pass (google.com: domain of adrian.klaver@gmail.com designates 10.68.221.73 as permitted sender) smtp.mail=adrian.klaver@gmail.com; dkim=pass header.i=adrian.klaver@gmail.com Received: from mr.google.com ([10.68.221.73]) by 10.68.221.73 with SMTP id qc9mr4148362pbc.139.1330352234253 (num_hops = 1); Mon, 27 Feb 2012 06:17:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; bh=9pvwbjBwY/V6ooW+l4OQKye+ERPYt9tKmgqwzf1lOa8=; b=elL1hDJT0tQs9OukMP/PG2ItsfgTKRgwTpqkh4V2yaUx7e23o50xffHc61ibFs2Vub wEJNswosTxwVCsisVvjMxtETA/bQCD6JZCINJ8Y/HFHLjaX/dZblecy0ajuQC0frVxbk w6qo0puvkgJhNZyOpUcV7SKUq8o5k7I0XnEuc= Received: by 10.68.221.73 with SMTP id qc9mr3543766pbc.139.1330352234152; Mon, 27 Feb 2012 06:17:14 -0800 (PST) Received: from tucker.localnet (c-24-17-164-54.hsd1.wa.comcast.net. [24.17.164.54]) by mx.google.com with ESMTPS id f9sm12806762pbq.60.2012.02.27.06.17.12 (version=SSLv3 cipher=OTHER); Mon, 27 Feb 2012 06:17:13 -0800 (PST) From: Adrian Klaver To: pgsql-sql@postgresql.org Subject: Re: Problems with ODBC connections Date: Mon, 27 Feb 2012 06:17:09 -0800 User-Agent: KMail/1.13.5 (Linux/2.6.32-38-generic; KDE/4.4.5; i686; ; ) Cc: Sandeep Reddy References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201202270617.10274.adrian.klaver@gmail.com> X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201202/86 X-Sequence-Number: 36379 On Saturday, February 25, 2012 10:05:07 am Sandeep Reddy wrote: > Hi, > I am completely new to postgres and I have some problems with ODBC > connection. > 1) I am running postgres server in Fedora Linux, and I am planning to > connect server from windows client. > 2) I have installed 64bit version of postgresql ODBC drivers > 3) I am making sure that my postgres is running with -p and > -i option to accept remote connections. > > Still I am getting error saying Connection can not be established. Any > quick pointers are highly appreciable. The actual error message would be helpful:)? A common reason for this is a firewall between the client and server that is preventing connection to the server port. Another reason is a pg_hba.conf that has not been configured to allow connections from the client. -- Adrian Klaver adrian.klaver@gmail.com