Обсуждение: Windows XP - ODBC

I download the Windows version of PostgreSQL using CgyWin.

I also down loaded the latest PGAdminII which installed a ODBC driver.

When I try to connect with my ODBC tools WinProfessionalSQL and PGAdminII I get the following error.

SQL Error State:08001, Native Error 65, ODBC Error: Could not connect to server.  Could not connect to remote socket.

The server is running, however, it is on the same machine.

Also attached in my config.  I read to enable_sockets so I tried to do so in the config?

I really need to get ODBC to work.  Hope I don't have as much trouble with JDBC.

If any could help, I would be extremely grateful.

Thanks!

Bob Lugering

sent replys to :
blugering@cfl.rr.com

Hi Bob,

On Tue, 2003-04-08 at 23:12, Bob Lugering wrote:
>
> When I try to connect with my ODBC tools WinProfessionalSQL and PGAdminII I get the following error.
>
> SQL Error State:08001, Native Error 65, ODBC Error: Could not connect to server.  Could not connect to remote socket.
>
> The server is running, however, it is on the same machine.
>
> Also attached in my config.  I read to enable_sockets so I tried to do so in the config?
>
> I really need to get ODBC to work.  Hope I don't have as much trouble with JDBC.
>

Just guessing, ... do you run your postgresql with "-o -i" option
(TCP/IP) or do you have an entry mapping your client IP address in your
pg_hba.conf to allow his access?

It's just a guess since I'm not aware of the SQL error codes...
________________________________________________________________________
regards,
Pedro Salazar.
--
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61