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


From: Alfonso Peniche <alfonso(at)iteso(dot)mx>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re:
Date: 2001-02-19 17:34:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Check the following list of steps and see if you have followed all of
them. This should work

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
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
            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 don't need a user for unix,
would suggest, for security reasons, that you take advantage of this
            NOTE 2: You have to modify your pg_hba.conf file so the
connection privilege is 'password' (no quotes). Also make sure you
have the connection privileges to the database from the machine you want

to make the connection.

            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, since I
tried the new version for the ODBC driver)

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).

Mustafa Attari wrote:

> Hi, I have installed PgAdmin-7.0.5 and MDAC 2.6 RTM (2.60.6526.3) (not
> SDK) on my Windows-NT client,and PostgreSQL-7.0.3 on Red Hat Linux
> Server 6.2, BUT the moment I execute PgAdmin, I get thefollowing
> error,
> "-2147467259                            Could not connect to the
> server                             Could not connect to the remote
> Socket" Myself and my colleague have tried all the possibilities but
> couldn't succeed, I hereby request yourkindself to guide me in solving
> the above problem. ThanksMustafa Attari

In response to

  • at 2001-02-17 03:59:34 from Mustafa Attari

pgsql-odbc by date

Next:From: Tom LaneDate: 2001-02-19 23:24:25
Subject: Unportable code in odbc's dlg_specific.h
Previous:From: JosephDate: 2001-02-19 15:21:38
Subject: Postgresql and Foxpro

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