| Lists: | pgsql-odbc |
|---|
| From: | Mie Kie <miekie(dot)lie(at)gmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | odbc win.xp and mandrake 10 |
| Date: | 2005-07-28 12:10:28 |
| Message-ID: | 42E8CB34.1010609@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Mie Kie <miekie(dot)lie(at)gmail(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: odbc win.xp and mandrake 10 |
| Date: | 2005-07-28 13:21:42 |
| Message-ID: | 42E8DBE6.2080504@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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
| From: | "Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(dot)com> |
|---|---|
| To: | Mie Kie <miekie(dot)lie(at)gmail(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: odbc win.xp and mandrake 10 |
| Date: | 2005-07-28 13:45:50 |
| Message-ID: | 42E8E18E.2080604@us.michelin.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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 | Content-Type | Size |
|---|---|---|
| greg.campbell.vcf | text/x-vcard | 241 bytes |