Re: MS Client ODBC question

Ok thanks, when I changed the pg_hba.conf authentication field from 'crypt'
to 'password' I was able to connect from my Win 98 box using ODBC (tables
look good from Excel->data->import->query).

Are there any plans to to make the Postgres Win ODBC driver support
connections using authentication by crypt or Kerberos?

Regards,
Jim Piper

-----Original Message-----
From: Brent R. Matzelle [mailto:bmatzelle(at)yahoo(dot)com]
Sent: Friday, November 09, 2001 09:36
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] MS Client ODBC question

--- "PIPER,JIM (A-SantaClara,ex1)" <jim_piper(at)agilent(dot)com>
wrote:
>
> I have pgsql 6.5 installed on HPUX with an entry in the
> pg_hba.conf file
> that says:
>
> host all 0.0.0.0 0.0.0.0 crypt
>
> I am trying to connect to it from a Win 98 box that I have
> installed the
> psqlodbc_07_01_0008 ODBC driver on.
>
> I can't get it to connect. I get back errors from my client
> app that says
> something like:
>
> "Password crypt authentication not supported"
>
> Why is this? Is it because the psqlodbc driver does not know
> how to send
> crypted passwords to the pgsql server?

That is correct.

> Is there some other
> ODBC driver for
> Win 98 that does support crypt?

I doubt it.

> Will things work if I change
> my pg_hba.conf
> file authentication field to be 'passwd'? or 'trusted'?

trusted would allow you access.

Brent

__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster