Обсуждение: Installation problems
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?
Thank you very much.
Bob Bachman
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