Thread: I cant' configure ODBC

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

Para: Tamara D. Blum

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

To: 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.

 

That is my configuration:
Database: template1

Database template1 doesn't seem to be a good idea.
Create a database and use that one.
Which Version of PostgreSQL are you using? 7.0X I guess.

regards

Johann




Johann Zuschlag
zuschlag2@online.de

On the linux platform you have to set a config file to allow
certain hosts to connect to Postgres.

Something about...

127.0.0.1/32 trust

--
Keith Gray

Technical Development Manager
Heart Consulting Services P/L
mailto:keith@heart.com.au

    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:
- Stuart

> -----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.
>

    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.
>

-----Original Message-----
From: Keith Gray [mailto:keith@heart.com.au]
Sent: 24 August 2001 02:07
To: Tamara D. Blum
Cc: Johann Zuschlag; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] I cant' configure ODBC


On the linux platform you have to set a config file to allow
certain hosts to connect to Postgres.

Something about...

127.0.0.1/32 trust

--
Keith Gray

Technical Development Manager
Heart Consulting Services P/L
mailto:keith@heart.com.au

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


**********************************************
Any views expressed in this message are the sender's own, and do not
represent the views of Nailsea Family Practice or Woodspring Healthcare
Limited except where the sender specifically states them to be the
views of one or both of those organisations. This e-mail should only be
read by those persons to whom it is addressed. Accordingly, we disclaim
all responsibility and accept no liability (including in negligence) for
the consequences of any person other than the intended recipients acting,
or refraining from acting, on such information. If you have received this
e-mail in error, please accept our apologies and we simply request that
you delete this document. Any form of reproduction, dissemination,
copying, disclosure, modification, distribution and/or publication of
this e-mail is strictly prohibited.