Thread: 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@amphi.com
> -----Original Message----- > From: jim davis [mailto:jdavis@amphi.com] > Sent: 11 July 2001 21:09 > To: pgsql-odbc@postgresql.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? It sounds to me like you are =actually connecting to the template0 database rather than testdb. template0 cannot be connected to hence the error (currently the ODBC driver doesn't know that template0 is any different from any other database). Check your connection string/DSN is specifying testdb as the database to connect to. Regards, Dave.
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@amphi.com] > Sent: den 11 juli 2001 22:09 > To: pgsql-odbc@postgresql.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@amphi.com > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster