Re: odbc
От | Carlos Amaral |
---|---|
Тема | Re: odbc |
Дата | |
Msg-id | 3D242B2D.2080000@isnet.com.br обсуждение исходный текст |
Ответ на | odbc ("Roberto Benitez" <RBENITEZ@houston.rr.com>) |
Список | pgsql-interfaces |
Please, can anybody help too ??? I've installed Postgres 7.2.1 from RedHat 7.3 and received the same error message below. I have pg_hba.conf in '/usr/share/pgsql/data" and "var/lib/pgsql/data", but this message persists !!! I'm not using odbc !! I use zeos (a connect tool for Delphi) !!! It allways work fine, but with 7.2.1 not !!! thanks Andreas Kretzer wrote: >>On 02.07.2002 at 19:59 Roberto Benitez wrote: >>hi, i have a postgresql db set up on a linux server >>i can access it w/o a problem from that machine, but when i try to access >>it from odbc, i get an error >>it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User], >>[Database] >>i set up the pg_hda.conf to accept a given range of IP's or tried to at >>least. >> >>what else do i need to do? >> > > First, make sure you're using the correct pg_hba.conf in the postgres > data directory! Then restart postgres server to bring changes in effect. > > Second, you will need to create a data base user using the 'createuser' > command. Use your logon name on the remote machine as the user > name to create. > > If you have successfully connected to the database you still can run > into trouble if you forgot to allow access to the records in your > data base. Use 'GRANT SELECT ON <table> TO <user>' as a minimum > access-level. > > If you have no success with that, please post your pg_hba.conf and > the concrete values for "[IP Adress], ..." from above. And specify your > odbc client machine (just guessing: Windows, Access ???) > > Regards > Andreas > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > >
В списке pgsql-interfaces по дате отправления: