Received: from mail.ewol.com (mail.ewol.com [207.239.237.12]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f18FHAx90010 for ; Thu, 8 Feb 2001 10:17:10 -0500 (EST) (envelope-from webmaster@dhs-club.com) Received: from dhs-club.com [216.0.160.142] by mail.ewol.com with ESMTP (SMTPD32-6.05) id A881AB1F0108; Thu, 08 Feb 2001 10:17:21 -0500 Message-ID: <3A82B80B.AABD6D04@dhs-club.com> Date: Thu, 08 Feb 2001 10:15:23 -0500 From: DHSC Webmaster Organization: The DHS Club X-Mailer: Mozilla 4.73 [en]C-CCK-MCD compaq (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Alfonso Peniche CC: pgsql-admin@postgresql.org Subject: Re: Re: pgadmin References: <000801c08b76$1d11c700$28bc09ca@sekhar> <3A80283E.F4767534@iteso.mx> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/61 X-Sequence-Number: 661 I have successfully setup the driver on a win98 machine, but when performing the same process on a win2000 machine, I get the following error: ODBC--call failed, Password authentication failed for user 'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not open (#0) I have tried repeatedly, re-entering the user and password in case of typo error, but have had no success. I've even tried different settings in 'options'. Any suggestions? Thanks, Bill MacArthur Alfonso Peniche wrote: > > What you have to do is: > > For every database you have in PostgreSQL you have to: > > 1.- Select ODBC Data Sources in the Control Panel > 2.- Select the User DSN tab > 3.- Click on 'Add...' > 4.- Choose the ODBC Driver corresponding to PostgreSQL and click on > 'Finish'. > 5.- A Setup window will appear with the following: > Data Source: Type the name you will identify your driver > with (could be the name of your database) > Description: (Optional) Anything that will make you remember > what the database or connection is > Database: Type your database's name (where you are going to > connect). > Server: Type your server name (where Postgres is installed) > Port: If you use default values, leave 5432 as is, > otherwiase type the Postgres Port you are using. > Username: Type the name you will use to make the connection > Password: Type the user's password > NOTE 1: Remember, in order for this to work you have to have > a Postgres username and password (since you need a user for unix, I > would suggest, for security reasons, that you take advantage of this > feature). > NOTE 2: You have to modify your pg_hba.conf file so the > connection privilege is 'password' (no quotes). > > I haven't been able to make it work with 'crypt'. I don't > know if it's a bug or if it's meant to be that way or if it's just me > (maybe someone from the ODBC area could help us out here) > > 6.- In the Options (Advanced) section (still in the Setup window) click > on 'DataSources' > 6.1.- A new window will appear. Make sure that the only boxes > checked are Show Columns and Fake Index in the OID Options Section. > > If I didn't forget anything, this should work. > > Hope this helps. (If you have any question don't hesitate to ask). > > "Raghav Infotech Ltd [Chennai]" wrote: > > > We want to install the client at Windows machine. We had downloaded > > the pgadmin and installed in in windows2000 machine through windows > > installer. But we could not configure the DSN and get going. kindly > > help by pointing further documentation Regards, T.G.Sekhar,Raghav > > Infotech Limited,Chennai,India, -- Bill MacArthur Webmaster DHS Club