Обсуждение: Installation problems

On 03/25/2015 02:20 PM, Robert S. Bachman wrote:
> Hello,
>
> I installed PostgreSQL 9.0 along with the ODBC driver that came with the
> installer.
>
> I don’t see the (psqlodbc) Postgre ODBC driver in the ODBC Data source
> administrator dialog drivers tab.
>
> Do I need to do something else?

Let me guess, you are using a 64bit version of Windows?

See here:

https://odbc.postgresql.org/faq.html#6.8

>
> Thank you very much.
>
> Bob Bachman
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 03/26/2015 07:21 AM, Robert S. Bachman wrote:
> Thank you. Yes,  I'm using Windows 7 (64b).
>
> I invoked the dialog and setup a data source but I'm still having problems
> connecting.
>
> I attached a snippet of the driver setup dialog. When I hit the Test button,
> I get a
> Dialog stating. "Could not connect to the server; Could not resolve
> hostname."
>
> The Server entry in the dialog is: "PostgreSQL 9.0 (x86)(localhost:5432)"

PostgreSQL 9.0 (x86)(localhost:5432) is just an identifier pgAdmin
creates to differentiate servers in the their server tree dialog.

Assuming the server is on the same machine as the ODBC driver then the
Server entry should be:

localhost

If the ODBC client is remote to the Postgres server then the Server
entry would be the

IP address, say 192.168.0.56

or a hostname, say dbserver.example.com

>
> The second attachment is a snippet of the pgAdmin dialog that  shows the
> Server name and the databases.
>
> We have an application that uses OTL to connect to various databases and
> we've recently
> Received a request from a customer for PostgreSQL.
>
> Any help you can provide would be greatly appreciated.
>
> Thank you again.
>
> Bob Bachman
>



--
Adrian Klaver
adrian.klaver@aklaver.com