Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDADx-00GQLd-On for pgsql-odbc@arkaria.postgresql.org; Mon, 18 Nov 2024 22:28:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tDADv-008KjE-4f for pgsql-odbc@arkaria.postgresql.org; Mon, 18 Nov 2024 22:27:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDADu-008Kj6-Pk for pgsql-odbc@lists.postgresql.org; Mon, 18 Nov 2024 22:27:59 +0000 Received: from mail-co1nam11on20710.outbound.protection.outlook.com ([2a01:111:f403:2416::710] helo=NAM11-CO1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDADo-002dwF-N6 for pgsql-odbc@lists.postgresql.org; Mon, 18 Nov 2024 22:27:58 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=UjYvD3SPDTNlU5myfZddcI15xYsnxcDfXKJYzUgxLJdwli+38EOoJpWbTunm/5yikqLS+QKBFPZ2H3pqVtlsoeSfA6T6uhpTKzuDEXzKn/iB0apdN0SbHf+wzbKKf1+iyBhGsLp050Buse2efoEtBxrPq1pdlRewaodHxl9ul7notitPWQNl0cj2HggJfHZEr4JDln4NQPYJIArIUR/CCOsgNpK2WuF/bVDhsu9UT6uEnrnXr1DAanwKlRSUC0Bu4Lvit+4oph/YR9fgnvM2DjBpb79nnkEE4k8DV6FOBX/ojm1CheFAmhxBNgNnbj/JP9FEWXw+LxBlGvauD7sv0g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Ji1m6Mn0+keRqhJGUAkQFdNhSa1pHjVAxFixFIoZM0o=; b=CXkvpfgdSsvGD74WhPdBpvnNOYRnY6ckZE/Pkv7G+HTDXx54wSvcp4hHyG3sChqm21SpRdK8CVINM3ZU5bGG8JjlBmxDBLxhJMkC++p8EH0vM5JBwVOljFANStBateDzzIaAz4CrM9kiljPuFbisd7IVnDP25JZB2nWbdQAcLcEmrP+hHfkuthXpLyjloqfyeItd9p3n4jAwrzzvB7i4CLTwDuk8FVBh8EO2MJOjniWiFGkggkXQbi6ppiXz5tRilpHbEqOXjnDFFsh+kE2Vz4yvYBNK9BxT8oZ6k+R+zrLHLNj91vzwLyYlzhGa97gT0s7DJypVYWczZHUNR+81vg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=spiralxllc.com; dmarc=pass action=none header.from=spiralxllc.com; dkim=pass header.d=spiralxllc.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=spiralxllc.onmicrosoft.com; s=selector1-spiralxllc-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Ji1m6Mn0+keRqhJGUAkQFdNhSa1pHjVAxFixFIoZM0o=; b=JgaReJcPDvqGGWNTloVR08kB+mcc9sqQ2/sGSEF4CvSznAuaw4xnyfefmpgCctC0hsvEzZ/xYDCW80w8Jej/IPTFrLadH1q4rIfh+LciYL6JNJp3NDxPeK6S7B15LzAc+/RqT34GVaeNJF11bMa4RB9jLnrr7ZzQiJZsZpAWyjQ= Received: from CYYPR11MB8306.namprd11.prod.outlook.com (2603:10b6:930:c6::20) by DM4PR11MB7277.namprd11.prod.outlook.com (2603:10b6:8:10b::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8158.22; Mon, 18 Nov 2024 22:27:43 +0000 Received: from CYYPR11MB8306.namprd11.prod.outlook.com ([fe80::ffd2:271:191b:4ddb]) by CYYPR11MB8306.namprd11.prod.outlook.com ([fe80::ffd2:271:191b:4ddb%4]) with mapi id 15.20.8158.019; Mon, 18 Nov 2024 22:27:43 +0000 From: Steven Adams To: "pgsql-odbc@lists.postgresql.org" Subject: ODBC configuration problem Thread-Topic: ODBC configuration problem Thread-Index: AQHbOgjCZMjrF10evU60nfmredjfEg== Date: Mon, 18 Nov 2024 22:27:42 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=spiralxllc.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CYYPR11MB8306:EE_|DM4PR11MB7277:EE_ x-ms-office365-filtering-correlation-id: fc8f67d1-9d2b-46e8-1b65-08dd0820381c x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|8096899003|38070700018; x-microsoft-antispam-message-info: =?iso-8859-1?Q?ht16Kl7lkQaseRpEBfYM56MaKurjcdOtZUZ/UuDd2yTKsTYVmfnnN0bdyN?= =?iso-8859-1?Q?CJLzP/hTt/UDUa/8ciJr1t5KUfRVjbEtPbhNCVjF/dyFUBC38ZXDTxclyh?= =?iso-8859-1?Q?WZgh2FbTSB17A6dfRAKKJ94ckLu2GleA4/vwCnmNKVIVaeYrfsNR/xFOM7?= =?iso-8859-1?Q?HnwrPSoM3onghfPfqhTP56kk/yl5VIUHTSMl0ibH1zsinlqRacDKmBKhrL?= =?iso-8859-1?Q?5m5STPzkB0Nh9MhA7lkBoYQBWdDqhAzQnqgiHG+LAz/UzM4qoek5DQYzLz?= =?iso-8859-1?Q?hmTuFhaoSs7ds4TL9wLpKaD70jkNi95l1Q0ZAIAoUFeE9q/UzD4drX7Cib?= =?iso-8859-1?Q?bZdjx2FeFHS/CGdLy8cKXS/Hwy8ml2WtmnvhzcgPoAkHqeRe/5A0eH6H1I?= =?iso-8859-1?Q?cCKJdC6O3oTEHniRgHT/9ZtxlOATjmwYKKJ1Fzx7t8LrAVJcMFwlIU9Utd?= =?iso-8859-1?Q?8KaE5brKnD4u7dROrmAhHBtzYTw5FDJa4RZXDnXVBcTU6ORmvYZiioO0gp?= =?iso-8859-1?Q?ujfsydEyShaZRx6R4xVjd5I30KVdFftLMp02wtp4/dvss9kJIDirf5G4vq?= =?iso-8859-1?Q?2VQRV04jqDas2ppFuoSTkQk4qW3cfV+Fih+ccapANlZ8WsHGmzHGVLJ8gy?= =?iso-8859-1?Q?XWSC5mrqZfWCMp3MyYld6JC54YMRi5JGq0IhHaqK2pubs+BoOQtA5gsETb?= =?iso-8859-1?Q?jixiUMgtY0KMFwZO8NhnDA+Xsw4legA6ZydfygtwQfXqLvbDWLYfL5v1AQ?= =?iso-8859-1?Q?oMWlGOpwnWB/N4MWOM/+xNKzdMaMA/Lutj/B8CPy/vwuuUL9A57N+V3yCl?= =?iso-8859-1?Q?UDBrMlroTY/wZI9RVFZ0kTVUbJhB5UFDIH9Fx26XBOc7JbtwOrd37dQZK0?= =?iso-8859-1?Q?nrIJZrMhdLEfPrCn6XVulXBhW6hu7gc5Pf1OVVF6PTEqhn8hnlqMLkYXNp?= =?iso-8859-1?Q?ztpnMtLD/OS6/+pAV7yMMaF4xj7f95jBGaFSfM33sTb7vVwPJLBKYwWY48?= =?iso-8859-1?Q?uuehFQTqUChF7EQgQyimFbYAZPqag+gdSSiTOHLEfa+lYQ9jGXPT/2l7Js?= =?iso-8859-1?Q?gWFCh3lBNL2p61i4B897VlCbYb3HHWEUSCVzR3R3z7dV+ST6Od2MWh182h?= =?iso-8859-1?Q?1iflt+ZB/zP17IAZljX3jBXptW8kYfUG7Epk7hvwZzKvTjhm3WcUcFFNOv?= =?iso-8859-1?Q?S05VXbvJjp1seXsvX1aKNAEgxcAbKXUqZhsf3RkBznsevj8ET32YRtrMQ2?= =?iso-8859-1?Q?wLHjuuFS+kFUXMkRY8tkG2FyggW1PWoFvl1gEPTgGzr7m2OFBLO/ckb639?= =?iso-8859-1?Q?E+bF255mQH4xd8/SPem31FoIDtFc9aoVabRkYAi5391YdGfljRNITEdjOU?= =?iso-8859-1?Q?HZIvytM1F60AkVK79poVxjNXSQeWCnzUcjug7C7u3BHEGiCHFy7QKdPFTf?= =?iso-8859-1?Q?4bxFlYaKWBs/r+Jr?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CYYPR11MB8306.namprd11.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(8096899003)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?MHpm7fcFVt5NO5ppSFOh4865Qh2XvlVs6bY9nj7cOoPJQvo/o35H8IAuvy?= =?iso-8859-1?Q?c/OitQuQ78UGcDWvbpCueujGc4E7sUBRbJEtUWNAjoo4JtdfHVtApBJB06?= =?iso-8859-1?Q?B+HPb+Ix128sQEeDxOq9TBn4WqtAqjOFWra7hPY+2pWTaNofz+oqCXt2av?= =?iso-8859-1?Q?6OOgwKKGtlvKr16YFOVhqY8SbuS5/Gpb/LrCP5YFax46SNnTbg7ggZJXr3?= =?iso-8859-1?Q?ZTWAlCXM0oucfAUpSIs5C9hLzBNvcu5xLa1vQL1+YetwBqobLDs6xQY0dZ?= =?iso-8859-1?Q?crl4ThFRlVPyA4I6tUNKCyxGay5ZTf/RQN1VhehYFn9iTgbdjCGEocvnmr?= =?iso-8859-1?Q?4AOIrtSCwka7kfk16k5IcHfHZJoIHEpnbdlSUmt4fQwJcWhVKBbZMklTzw?= =?iso-8859-1?Q?CtxN5pWegGgumDcsmRdc7QuBqnckwZ/uny5Ic7RHF69PozE3Z19L7jND3m?= =?iso-8859-1?Q?5aK8zm7UeD/jwYjx0B9Wyl5Rlo9Yxez7B9/U4u39c+IWk6pmjkHvveUHE1?= =?iso-8859-1?Q?ZgITsyam3O5OgrLrZp/wvq+n/cBe3odeM9G8YqFS75bMQhN8EK0PRca9wC?= =?iso-8859-1?Q?ZFqFvzOiHzJMlE+XSYdv7/M+Q0pVcypjapehZjXcfjALwiAj12Am/dcqjM?= =?iso-8859-1?Q?Ts06IwZV96o/A8E65IisaEjSFw8JaI+6x8qqiX5DymKzyC3HwVfSmfYCrL?= =?iso-8859-1?Q?ljB+zykShF574eg0f2EaQbyWR+b1XvD4ikxAKopyVMkty9zszjaR/qB58J?= =?iso-8859-1?Q?gpMqM70bRJeIWIqHeXc/vi84DXayV5rFguzHoMAWipaGZDnLzjtIrEXIz8?= =?iso-8859-1?Q?4uGPiu/y+do1kaAyCuGYjVe7TCRoyphcV/UrWzbH4657p6kyMcOfk3SvYy?= =?iso-8859-1?Q?LBMtbv30QxO7MMITZNo5lHbKQd3HeLdRlZUKJWwmSpBnsZmf4KcgPh2KWp?= =?iso-8859-1?Q?mwF+kjE0RBMP9Ofs1F4NOYscZ1DqmwPnKtNKyHTl1U3iGYTOI5r2u59M2s?= =?iso-8859-1?Q?kxRWO0q5nKwY3P4CWeswJPiEM3QTtugBqi2/X+kufT3S35l3/xvokpVfB3?= =?iso-8859-1?Q?bF73xi/OI1bdmJYxYkGH0ekg/75jGcrrfRojMFBfECoYVY5Ocm5ITLhSLO?= =?iso-8859-1?Q?IRzAaTxM7xim7akn0cgTexo9B0sRNvoTERVQjdbdofBqb6HK7REB9fkKdo?= =?iso-8859-1?Q?VuHGbm95T0/MgdYrwIYLGymgRpOP0/9SjTMeztpt2rFJlj13VXnGhtQ48a?= =?iso-8859-1?Q?PDUQxW/r28LArVarTshOIC1xHeG+z7t3nG3XilAUaR2mpBjEx1cNHFvAX4?= =?iso-8859-1?Q?2fOxYSL1OlgkcVfgrhueram3cxA4sKFhR7VUr45xjIn7wnZb2ylmj5zcvq?= =?iso-8859-1?Q?4qAif9U4Pkifh2oR5Lqt9UEnW/1VgVMe0eUSYw+xuQFqg3Rahu9/qB2Gr0?= =?iso-8859-1?Q?vhw1X1+z1cC+TmAi4zVem3M+79WXyrXLAyf8VJbECXU0xtYrBrkNqVIosE?= =?iso-8859-1?Q?ZTCfuzJ1nmBf+NgQ4MV7EZFcFXbc7Qt2FMJHLGp8G0kmwYEtjWvKMpOouj?= =?iso-8859-1?Q?MSVQPyZTO4MuK8EfNCSk/8WzEPqKgsiSoKgEwXFqBhPUwz3bBpma82O8c0?= =?iso-8859-1?Q?Adru18cJd1LPbFQQu9ABVBpcokD2xK+H5+?= Content-Type: multipart/alternative; boundary="_000_CYYPR11MB8306FC280BF8B21A209F9B55DE272CYYPR11MB8306namp_" MIME-Version: 1.0 X-OriginatorOrg: spiralxllc.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CYYPR11MB8306.namprd11.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: fc8f67d1-9d2b-46e8-1b65-08dd0820381c X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Nov 2024 22:27:42.9767 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 4e3f5e01-32e9-4a96-bb55-9de831f28b26 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: F4qY2PR2cY6brqR4yo5UlH2cI4s0lN6iyzBldo9UkWAR9wlR99ujU2YIK7Tc2VBkVvmwMq7PdHGDqnueIzGNfIzb6O3MMvACYC7iq4aOFos= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM4PR11MB7277 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CYYPR11MB8306FC280BF8B21A209F9B55DE272CYYPR11MB8306namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I'm trying to use MS Access with PostgreSQL and so want to configure an ODB= C file for this. Testing it resulted in a connection timeout, so I looked = at this to troubleshoot: https://odbc.postgresql.org/faq.html#3.3 Adding a "tcpip=3Dtrue" line to postgresql.conf and a line to permit a conn= ection from the computer running Access to pg_hba.conf and then restarting = PostgreSQL seemed to go without errors, but when I tried to run the psql co= mmand afterward, I got this error: psql: error: connection to server at "localhost" (127.0.0.1), port 5432 fai= led: Connection refused Is the server running on that host and accepting TCP/IP connections= ? The psql command worked again after I undid these changes, so I'm trying to= figure out how they caused this error. The line I added to pg_hba.conf wa= s as follows. host spiralxprime web_app 192.168.0.72 scram-sha-256 Any ideas as to why this is happening would be appreciated. Regards, Steven Adams --_000_CYYPR11MB8306FC280BF8B21A209F9B55DE272CYYPR11MB8306namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,

I'm trying to use MS Access with PostgreSQL and so want to configure an ODB= C file for this.  Testing it resulted in a connection timeout, so I lo= oked at this to troubleshoot:
Adding a "tcpip=3Dtrue" line to postgresql.conf and a line to per= mit a connection from the computer running Access to pg_hba.conf and then r= estarting PostgreSQL seemed to go without errors, but when I tried to run t= he psql command afterward, I got this error:
psql: error: connection to server at "localhost" (127.0.0.1), por= t 5432 failed: Connection refused
        Is the server running on that host and acceptin= g TCP/IP connections?

The psql command worked again after I undid these changes, so I'm trying to= figure out how they caused this error.  The line I added to pg_hba.co= nf was as follows.
host      spiralxprime     web_app  &nbs= p;  192.168.0.72     scram-sha-256

Any ideas as to why this is happening would be appreciated.

Regards,

Steven Adams

--_000_CYYPR11MB8306FC280BF8B21A209F9B55DE272CYYPR11MB8306namp_--