I just went through the same problems you and Jim Burnett are describing. Here is what I got to work and how I did it. (Remember I am new to both Linux and Postgres so there may have been an easier way.) I am on a RH 5.0 system that installed Postgres from the RH cd. It puts Postgres 6.2 on your system. I looked at the doc's on Postgres's web site for installing and running it. The install docs are important even though it's already there since that's where they describe adding access from other machines and users. First, I tried psql from the localhost and it worked. That assured me Postgres was functioning alright. I wanted to set up an odbc connection from a windows machine so I edited the pg_hba.conf file that was in /var/lib/pgsql by uncommenting a line that the doc lines within the file said would allow anyone from anywhere to connect to any db. After saving it, Postgres wouldn't let me connect from anything even psql. Then I noticed that I was root on the Linux machine to edit the file and remembered the web pages emphasizing being someone other than root when installing Postgres. A quick look at ls -al showed me that RH had installed everything under a user named postgres. So I chown'd the pg_hba.conf file to make it owned by user postgres. Now psql started to work again. Then I downloaded the latest odbc driver. Installing it and configuring it produced the odbc failed message you both mentioned. However on Posgres's web site there's a faq that mentions that and another message. It says each version of Postgres uses a different protocol and you must configure the odbc driver to use the right one. There's a button named data source within the advanced section that lets you change the protocol. Having done that odbc began to function. Hope all this helps you both. At 10:23 AM 5/27/99 -0800, Herbert Ambos wrote: >Thanks to those who helped me yesterday... i finally got it run...(linked >a table using MS Access). But it turned out that when i opened the >linked-table it displayed errors on its records. why? I doubled checked >the Postgres version.. it's OK. And when i tried to link redo the >linking it displayed: > > ODBC -- call failed. > Unsupported frontend protocol (#210). > >What does this means? > >Please help. > >------ * - * - * ------ >Herbert Rabago Ambos >MS Computer Applications >School of Graduate Studies >MSU - Iligan Institute of Technology >9200 Philippines > >home: +632 63 2212483 >mobile: +632 973384423 > > > >
