RE: fatal ODBC error?

> -----Original Message-----
> From: jim davis [mailto:jdavis(at)amphi(dot)com]
> Sent: 11 July 2001 21: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?

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.