Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA20493 for ; Fri, 21 Aug 1998 09:29:10 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA04332 for pgsql-interfaces@hub.org; Fri, 21 Aug 1998 09:00:38 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA20843; Fri, 21 Aug 1998 08:53:14 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA26012; Fri, 21 Aug 1998 08:53:14 -0400 Message-Id: <35DD6EBD.4D78207@insightdist.com> Date: Fri, 21 Aug 1998 08:57:33 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "Roeland M.J. Meyer" Cc: LIST - PGSQL Interface Subject: Re: [INTERFACES] Remote access ODBC/MS-Access References: <199808210658.XAA19347@condor.mhsc.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit There is a checklist on http://www.insightdist.com/psqlodbc/psqlodbc_faq.html. Off the top of my head: Did you start postmaster with the -i option? Roeland M.J. Meyer wrote: > This is probably a newbie question, or one that's already been seen before. > However, I'm new to PostgreSQL. I've been researching the dox since > Wednesday, to no avail. I have already called MS and they were as helpful > as they could be. Decent help on MS-Access and they have me on ODBC Manager > v3.5. I am reasonably confident that the System DSN is correctly done. > > Client-side: > WinNT40SP3 > Version of MS-Access is from MS-Office97 SR1 > ODBC Manager v3.5. > > Server-side: > I have the following installed on a heavily modified Caldera OpenLinux > (standard) box. Kernel is at v2.0.33. > > Postgres version is "postgresql-6.3.2" > PostODBC version is "PsqlODBC-6.30.0249.exe" > > LAN is 100baseTX (switched) on /28 > > PROBLEM: > > I can not seem to access the data server. I did a parallel install, on a > similar server on the same sub-net. I set PGHOST and PGPORT as advertised > and I get the following error; > > >postgres@condor:/rdbms$> psql customerdb > >Connection to database 'customerdb' failed. > >connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port > '5432'? > > Note: customerdb exists with only one table, the "bar" from the Admin Manual. > > I get similar dialog boxen from the NT machines. > > My "pg_hba.conf" looks like this (unitl I get this working): > > >host all 199.108.175.0 255.255.255.0 trust > >local all trust > >host all 127.0.0.1 255.255.255.255 trust > > Please respond via regular e-mail, as well as to the list. > > PS. This is definitely NOT Oracle > > _________________________________________________ > Morgan Hill Software Company, Inc. > Colorado Springs, CO - Livermore, CA - Morgan Hill, > CA > Domain Administrator > MHSC2-DOM and MHSC3-DOM > Administrative and Technical contact > ____________________________________________ > InterNIC Id: MHSC hostmaster (HM239-ORG) > e-mail: mailto:hostmaster@mhsc.com > web -pages: http://www.mhsc.com/