Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] fatal ODBC error?

From: jim davis <jdavis(at)amphi(dot)com>
To: Christian Bucanac <christian(dot)bucanac(at)mindark(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [ODBC] fatal ODBC error?
Date: 2001-07-13 15:35:04
Message-ID: 3B4F1528.7304951E@amphi.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-novicepgsql-odbc
Thanks!! the -i option was the key.

-Jim

Christian Bucanac wrote:
> 
> You have to
> * start postmaster with the -i option, see man postmaster
> * add host config to pg_hba.conf, see pg_hba.conf
> * enter the right configuration in the odbc driver
> * make sure the user you are connecting as exists in the db, see createuser
> 
> /Buckis
> 
> -----Original Message-----
> From: jim davis [mailto:jdavis(at)amphi(dot)com]
> Sent: den 11 juli 2001 22:09
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] fatal ODBC error?
> 
> I posted this on the "Novice" list, but the more I think about it, I
> more I think it should be asked here.  I have downloaded the 7.1.2
> version of PostgreSQL and ./configure'ed it with --enable-odbc and
> gmake'd install-with-full-headers, I started it with
> /usr/local/pgsql/bin postmaster -D /usr/local/pgsql/data.  Then I went
> in with "Webmin v. .82" and  opened it up so any host can see any
> database, created a "testdb" database.  I then downloaded from a
> postgresql mirror the pgsql_ODBC drivers and installed it on my win2k
> box.  then when I try and access the testdb database with the ODBC
> driver, I see on the server, an error that says, "FATAL 1: Database
> template0 not accepting connections" and the win2k box cant connect...
> help?
> 
> -Jim Davis
> Network Coordinator II
> Amphitheater Public Schools
> Voice:  (520)696-5120
> Fax:    (520)696-5070
> e-mail: jdavis(at)amphi(dot)com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


In response to

pgsql-novice by date

Next:From: jim davisDate: 2001-07-13 15:44:44
Subject: Silly newbie questions
Previous:From: Sykora, DaleDate: 2001-07-13 15:18:30
Subject: RE: Serial field

pgsql-odbc by date

Next:From: Jose Luis FerreiraDate: 2001-07-15 16:38:24
Subject: postgres odbc for windows
Previous:From: Christian BucanacDate: 2001-07-12 07:50:01
Subject: RE: [ODBC] fatal ODBC error?

pgsql-interfaces by date

Next:From: Darko PrenosilDate: 2001-07-13 23:40:14
Subject: LIBPQ WIN32 NON-BLOCKING
Previous:From: Sandro DentellaDate: 2001-07-13 09:35:27
Subject: Re: pgaccess - international characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group