Could there be a case issue? Try creating a lowercase only name and
seeing if you can connect via that.
Maybe try adding this line to the pg_hba.conf:
host all 0.0.0.0 0.0.0.0 trust
This'll grant everywhere trust login (no password, just username), so it
should test if your pg_hba.conf file is the problem.
- Stuart
PS Sorry for the previous truncated mail - I'll learn to use a keyboard one
day, maybe :)
> -----Original Message-----
> From: Tamara D. Blum [SMTP:tblum@jus.gov.ar]
> Sent: Thursday, August 23, 2001 9:35 PM
> To: Ed Koffeman
> Cc: pgsql-odbc@postgresql.org
> Subject: RE: I cant' configure ODBC
>
> Ed,
> i tryed also with my password (the login name is the same in Windows).
> Is there something i forgot to make in Cygwin's side ?
> Any command i have to execute to check if the option ODBC is installed
> correctly ?
>
> Thanks
>
>
>
> I had to put in my regular Windows login name and password before it would
> work for me.
>
> it gives me an error: "ODBC--call failed"
> That is my configuration:
> Database: template1
> Server: localhost
> Port: 5432
> User Name: TBlum (is the name that returns the command whoami)
> Password: (none)
>
> Any idea ?
> Thanks
>
> ----- Mensaje original -----
> De: Ed Koffeman <mailto:edk@abelcomputers.com>
> Para: Tamara D. Blum <mailto:tblum@jus.gov.ar>
> Enviado: Jueves, 23 de Agosto de 2001 16:38
> Asunto: Re: [ODBC] I cant' configure ODBC
>
> The "Server Name" needs to be set to "localhost"
>
> Ed Koffeman
>
> ----- Original Message -----
> From: Tamara D. Blum <mailto:tblum@jus.gov.ar>
> To: pgsql-odbc@postgresql.org
> <mailto:pgsql-odbc@postgresql.org>
> Sent: Thursday, August 23, 2001 2:03 PM
> Subject: [ODBC] I cant' configure ODBC
>
> Hi, i'm new in postgresql and i'm trying to
> configure the ODBC driver to access postgresql from Access and StarOffice.
>
> I downloaded an ODBC driver from internet and when i
> try to connect postgresql it ask me for a servername and i have installed
> it with CygWin in the same computer i try to access.
>
> I read a chapter about ODBC in postgresql
> documentation, but there are some files i don't have in my installation.
>
> Can anyone explain me how to install and configure
> ODBC ?
>
> Thanks
> Tamara.
>
