Fw: [NOVICE] Re: connecting OBDC - Mailing list pgsql-odbc

> yes.
> it's ok i can see postgres in the ODBC administrator panel
> there is 3 drivers PostgreSQL, PostgresSQL+(beta), PostgresSQL+(unicode).
> I have choosed the first one.
> after I put
>
> DATASOURCE : POSTGRES
> DATABASE : ?? I tried TEST (the database I have created), template1 ,
> c:\cygwin\usr\share\postgreSQL\data
> SERVER : 127.0.0.1
> user NAME : postgres
> Port : 5432 (default)
> Password : (void)
>
> everytime same error :
> SQL general error
> couldn't connect to the server
> couldn't connect to  remove socket.
> ALIAS : POSTGRES.
>
> while I can make SQL queries without problems under cygwin.
>
> ----- Original Message -----
> From: "Marc Birkett" <MBirkett@emc-ltd.co.uk>
> To: <valcauda.aderis@wanadoo.fr>
> Sent: Tuesday, October 01, 2002 12:52 PM
> Subject: Re: [NOVICE] Re: [ODBC] connecting OBDC
>
>
> have you downloaded to postgresql drivers?
>
> >>> valcauda Stéphane <valcauda.aderis@wanadoo.fr> 10/01/02 11:57am >>>
> Ok for 127.0.0.1. I didn't know that.
> but, while I like to understand things :), I try the ping on 127.0.0.1,
but
> it doesn't work (problem of delay).
> Anyway, I can connect to postgresql under cygwin without problem with
> psql -U postgres template1.
> It works.
> I don't understand why I have to put template1 while I made a CREATE
> DATABASE TEST , but I will find
> in the doc later (It's probably like under ACCESS o ORACLE with database
> workspaces).
>
> My problem is with ODBC.
> I would like to connect under C++ Builder. I need ODBC connection.
> It doesn't work.
> ODBC Manager ask me for DSN, DatabaseName and Server Name, but I don't
> succeed in connecting.
>
> The database name under ODBC should be template1 ?
>
> be novice is quite hard :) when you come from other environnement that you
> were mastering without problem.
>
> thanks.
>
> ----- Original Message -----
> From: "Marc Birkett" <MBirkett@emc-ltd.co.uk>
> To: <valcauda.aderis@wanadoo.fr>
> Sent: Tuesday, October 01, 2002 12:37 PM
> Subject: Re: [NOVICE] Re: [ODBC] connecting OBDC
>
>
> 127.0.0.1 is the IP address of your computer, whatever the actual IP
address
> is. If you open a dos prompt and ping 127.0.0.1 you ping your own
computer.
>
> The default to log-in to postgresql is:
>
> psql template1 postgres where:
>
> psql = client
> template1 = default database.
> postgres = default user.
>
> once logged in like this you can set-up a super user using CREATE USER
name
> CREATEUSER.
>
> >>> valcauda Stéphane <valcauda.aderis@wanadoo.fr> 10/01/02 11:42am >>>
> I don't understand your "to logon" part.
> Sorry :)
> In ODBC I have Server name, DSN Name and Database Name
>
> For my knowledge why 127.0.0.1 ?
> I don't have this IP.
>
> thanks.
>
> ----- Original Message -----
> From: "Marc Birkett" <MBirkett@emc-ltd.co.uk>
> To: <valcauda.aderis@wanadoo.fr>
> Sent: Tuesday, October 01, 2002 12:29 PM
> Subject: [NOVICE] Re: [ODBC] connecting OBDC
>
>
> try "127.0.0.1" as the IP address and
>
> to logon > psql template1 postgres.
>
> these are the default values, could you keep the thread in your replies as
i
> normally delete e-mails regularly.....
>
> >>> valcauda Stéphane <valcauda.aderis@wanadoo.fr> 10/01/02 09:51am >>>
> thanks for you answers.
>
> I have already had a look on the list's archive  but found nothing.
> I don't have system administrator, my network is very little (3 computers)
> but while I will use
> PostGres whith my student I make test on my own network before.
>
> I put the IP adress of my computer (which is the server)  but it still
> doesn't work.do it
> for me if the server is correct, I can see 2 problems :
> 1/ the database name. The help says that we should give the path of the
> database. With Postgres I have the
> classic usr\share\postgresql\data and my database is called TEST but I
don't
> see TEST directory or file. And I don't
> know if I should put the NT path (with CYGWIN root before) or the cygwin
> path usr/share/...
>
> 2/ The users password. I've got problem with the login command. I can
> connect on my account but I can"t change user
>    with login. I tried mkPasswd, put "" password. But it doesn't work.
>
> thanks for help
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> --------------------------------------------------------------------------
--
> The information transmitted is intended only for the person(s) or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient(s) is prohibited. If you
received
> this in error, please contact the sender and delete the material from any
> computer.
>
>
>
>
>
>
> --------------------------------------------------------------------------
--
> The information transmitted is intended only for the person(s) or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient(s) is prohibited. If you
received
> this in error, please contact the sender and delete the material from any
> computer.
>
>
>
>
>
> --------------------------------------------------------------------------
--
> The information transmitted is intended only for the person(s) or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient(s) is prohibited. If you
received
> this in error, please contact the sender and delete the material from any
> computer.
>
>
>
>