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

RE: [ODBC] fatal ODBC error?

From: Christian Bucanac <christian(dot)bucanac(at)mindark(dot)com>
To: "'jim davis'" <jdavis(at)amphi(dot)com>, "Pgsql-Odbc (E-mail)" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: [ODBC] fatal ODBC error?
Date: 2001-07-12 07:50:01
Message-ID: 5146853DD571D411AC54000102070D611C7F11@MINGBGNTS02 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-novicepgsql-odbc
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

Responses

pgsql-novice by date

Next:From: Jeroen HeijmansDate: 2001-07-12 09:06:42
Subject: Table type attributes
Previous:From: Oliver ElphickDate: 2001-07-12 04:12:10
Subject: Re: newbie question

pgsql-odbc by date

Next:From: jim davisDate: 2001-07-13 15:35:04
Subject: Re: [ODBC] fatal ODBC error?
Previous:From: Dave PageDate: 2001-07-12 07:17:17
Subject: RE: fatal ODBC error?

pgsql-interfaces by date

Next:From: Manika DeyDate: 2001-07-12 16:31:20
Subject: postgres access from windowsNT
Previous:From: GANGAPURAM JAIPALDate: 2001-07-12 04:43:39
Subject: Clob - Issue

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