Thread: odbc win.xp and mandrake 10

odbc win.xp and mandrake 10

From
Mie Kie
Date:
Hi,

I use Windows XP as Client and Mandrake 10.0 as Server. I have installed
pgsql 8 on mandrake 10. I tried to create connection with odbc but can
not work. But if i install pgsql 8 on another computer with windows xp
as a server, i have no problem to create connection with odbc. Anybody
can help me?

Mie Kie

Re: odbc win.xp and mandrake 10

From
Richard Huxton
Date:
Mie Kie wrote:
> Hi,
>
> I use Windows XP as Client and Mandrake 10.0 as Server. I have installed
> pgsql 8 on mandrake 10. I tried to create connection with odbc but can
> not work. But if i install pgsql 8 on another computer with windows xp
> as a server, i have no problem to create connection with odbc. Anybody
> can help me?

1. Is your postgresql.conf file set for PG to listen for internet
connections on the Mandrake machine?
2. Is your pg_hba.conf file set to allow connections from your Windows
machine?
3. Can you connect from the Windows machine using psql/pgadmin?
4. Can you connect to the Mandrake machine from another linux machine
using psql?
5. What do your system/firewall/database logs say?
6. When you turn on ODBC logging on the Windows machine, what do those
logs say?

--
   Richard Huxton
   Archonet Ltd

Re: odbc win.xp and mandrake 10

From
"Greg Campbell"
Date:
The problem could be that the PostgreSQL security is not allowing access?
Check that pg_hba.conf is configured for allowed addresses/user accounts.
Check postgresql.conf for the listen_address parameter.
and the  log_connection  parameter.

If neceesary update your postmaster startup to do logging to a known
location, or just for an exercise restart the post master with
pg_ctl -l log_filename.

Checkout the Postgresql 8.0 Documentation PDF, Chapter 16? It documents
most of the above.




Mie Kie wrote:
> Hi,
>
> I use Windows XP as Client and Mandrake 10.0 as Server. I have installed
> pgsql 8 on mandrake 10. I tried to create connection with odbc but can
> not work. But if i install pgsql 8 on another computer with windows xp
> as a server, i have no problem to create connection with odbc. Anybody
> can help me?
>
> Mie Kie
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

Attachment