Thread: [NOVICE] Re: connecting OBDC
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
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.
> -----Original Message----- > From: valcauda Stéphane [mailto:valcauda.aderis@wanadoo.fr] > Sent: 01 October 2002 12:24 > To: PostgreSQL Mailing List > Subject: Fw: [NOVICE] Re: [ODBC] connecting OBDC > > > > 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. > Make sure you started the postmaster with the -i option or tcp/ip enabled in postgresql.conf. Regards, Dave.
No, It wasn't -i with postmaster and TCP/IP socket was by default (so False). It makes me think of another thing. All is on my personnal computer : Windows 2000 workstation and CYGWIN. I had made the default CYGWIN installation. But does Windows 2000 ODBC drivers can communicate with CYGWIN postgreSQL session with TCP/IP. Should I install something else to make W2000 / CYGWIN be compatible under IP ? >>Make sure you started the postmaster with the -i option or tcp/ip enabled in postgresql.conf. >>Regards, Dave. > > > 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: valcauda Stéphane [mailto:valcauda.aderis@wanadoo.fr] > Sent: 01 October 2002 13:45 > To: Dave Page; PostgreSQL Mailing List > Subject: Re: [NOVICE] Re: [ODBC] connecting OBDC > > > No, It wasn't -i with postmaster and TCP/IP socket was by > default (so False). It makes me think of another thing. > > All is on my personnal computer : Windows 2000 workstation > and CYGWIN. I had made the default CYGWIN installation. But > does Windows 2000 ODBC drivers can communicate with CYGWIN > postgreSQL session with TCP/IP. Should I install something > else to make W2000 / CYGWIN be compatible under IP ? No, that should work fine. Here's a checklist: 1) Start the postmaster with -i or tcpip_socket=true in $PGDATA/postgresql.conf 2) Make sure there in an entry in $PGDATA/pg_hba.conf that will allow you access eg. host all all 127.0.0.1 255.255.255.255 password 3) Make sure tcp/ip is installed on your workstation (pretty hard not to these days). 4) Setup a system DSN for testing: Server: 127.0.0.1 Database: template1 All other options can be left at their defaults for testing. Regards, Dave.