Thread: pgadmin

What you have to do is:

For every database you have in PostgreSQL you have to:

1.- Select ODBC Data Sources in the Control Panel
2.- Select the User DSN tab
3.- Click on 'Add...'
4.- Choose the ODBC Driver corresponding to PostgreSQL and click on
'Finish'.
5.- A Setup window will appear with the following:
            Data Source: Type the name you will identify your driver
with (could be the name of your database)
            Description: (Optional) Anything that will make you remember
what the database or connection is
            Database: Type your database's name (where you are going to
connect).
            Server: Type your server name (where Postgres is installed)
            Port: If you use default values, leave 5432 as is,
otherwiase type the Postgres Port you are using.
            Username: Type the name you will use to make the connection
            Password: Type the user's password
            NOTE 1: Remember, in order for this to work you have to have
a Postgres username and password (since you need a user for unix, I
would suggest, for security reasons, that you take advantage of this
feature).
            NOTE 2: You have to modify your pg_hba.conf file so the
connection privilege is 'password' (no quotes).

            I haven't been able to make it work with 'crypt'. I don't
know if it's a bug or if it's meant to be that way or if it's just me
(maybe someone from the ODBC area could help us out here)

6.- In the Options (Advanced) section (still in the Setup window) click
on 'DataSources'
    6.1.- A new window will appear. Make sure that the only boxes
checked are Show Columns and Fake Index in the OID Options Section.

If I didn't forget anything, this should work.

Hope this helps. (If you have any question don't hesitate to ask).


"Raghav Infotech Ltd [Chennai]" wrote:

> We want to install the client at Windows machine.  We had downloaded
> the pgadmin and installed in in windows2000 machine through windows
> installer.  But we could not configure the DSN and get going.  kindly
> help by pointing further documentation Regards, T.G.Sekhar,Raghav
> Infotech Limited,Chennai,India,

I have successfully setup the driver on a win98 machine, but when
performing the same process on a win2000 machine, I get the following
error:
ODBC--call failed, Password authentication failed for user
'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not
open (#0)

I have tried repeatedly, re-entering the user and password in case of
typo error, but have had no success. I've even tried different settings
in 'options'.
Any suggestions?
Thanks, Bill MacArthur

Alfonso Peniche wrote:
>
> What you have to do is:
>
> For every database you have in PostgreSQL you have to:
>
> 1.- Select ODBC Data Sources in the Control Panel
> 2.- Select the User DSN tab
> 3.- Click on 'Add...'
> 4.- Choose the ODBC Driver corresponding to PostgreSQL and click on
> 'Finish'.
> 5.- A Setup window will appear with the following:
>             Data Source: Type the name you will identify your driver
> with (could be the name of your database)
>             Description: (Optional) Anything that will make you remember
> what the database or connection is
>             Database: Type your database's name (where you are going to
> connect).
>             Server: Type your server name (where Postgres is installed)
>             Port: If you use default values, leave 5432 as is,
> otherwiase type the Postgres Port you are using.
>             Username: Type the name you will use to make the connection
>             Password: Type the user's password
>             NOTE 1: Remember, in order for this to work you have to have
> a Postgres username and password (since you need a user for unix, I
> would suggest, for security reasons, that you take advantage of this
> feature).
>             NOTE 2: You have to modify your pg_hba.conf file so the
> connection privilege is 'password' (no quotes).
>
>             I haven't been able to make it work with 'crypt'. I don't
> know if it's a bug or if it's meant to be that way or if it's just me
> (maybe someone from the ODBC area could help us out here)
>
> 6.- In the Options (Advanced) section (still in the Setup window) click
> on 'DataSources'
>     6.1.- A new window will appear. Make sure that the only boxes
> checked are Show Columns and Fake Index in the OID Options Section.
>
> If I didn't forget anything, this should work.
>
> Hope this helps. (If you have any question don't hesitate to ask).
>
> "Raghav Infotech Ltd [Chennai]" wrote:
>
> > We want to install the client at Windows machine.  We had downloaded
> > the pgadmin and installed in in windows2000 machine through windows
> > installer.  But we could not configure the DSN and get going.  kindly
> > help by pointing further documentation Regards, T.G.Sekhar,Raghav
> > Infotech Limited,Chennai,India,

--
Bill MacArthur
Webmaster
DHS Club

At 10:15 2001-02-08 -0500, DHSC Webmaster wrote:
>I have successfully setup the driver on a win98 machine, but when
>performing the same process on a win2000 machine, I get the following
>error:
>ODBC--call failed, Password authentication failed for user
>'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not
>open (#0)


Are you yure, that you...
...started the postmaster with the -i option?
...have the correct settings in your pg_hba.conf?

Stefan