Re: pgAdmin/ODBC errors.

> -----Original Message-----
> From: Contejean, TiJana [mailto:tijana(dot)contejean(at)wcg(dot)com]
> Sent: 24 August 2001 22:02
> To: 'pgsql-odbc(at)postgresql(dot)org'
> Subject: [ODBC] pgAdmin/ODBC errors.
>
>
> Hello I am trying to install pgAdmin on my desktop. I am
> currently running Windows NT. I am accessing my server
> through a gui called putty.exe. My server is running
> PostgreSQL on top of Linux. The problem I am having is, I am
> not able to log onto pgAdmin. I keep an error of
> Error:-2147467259 [Microsoft][ODBC Driver Manager] Data
> source name not found and no default driver specified
> Function:frmODBCLogon, cmdOK_Click. I'm not sure of the exact
> error, but I think it is stating that I need to install the
> ODBC Driver for Postgres.

Yes, this is the most probably cause of the error. The ftp site is usually
very busy, so I suggest you try a mirror such as
http://sunsite.org.uk/Mirrors/ftp.postgresql.org/pub/odbc/. In your case, as
you have the Microsoft Installer, I would suggest you download and install
the latest 'msi' release (07.01.0006) of the driver.

Once installed, from the ODBC Driver Manager (found in the control panel),
create a new System or User Datasource using the PostgreSQL driver. You will
need to make sure that *both* Read-Only options are switched off, and that
Recognize Unique Indexes, OID Options -> Show Column and OID Options -> Fake
Index are all selected.

Once you done this, you can start pgAdmin, select your new DSN from the
combo box, enter your username/password and logon.

Regards, Dave.