Обсуждение: odbc win.xp and mandrake 10
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
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
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