Thread: Pgadmin

Pgadmin

From
"Susan Lane"
Date:
I've posted this on the INTERFACES list, but haven't recieved any response,
so hopefully someone here can help me.

I've downloaded pgadmin along with MDAC 2.6, psql ODBC driver, and windows
installer.  I can't even get connected.  It's giving me a password error
"Incorrect password: Connection to datasource: XXX failed!"  I've tried to
set up my DSN by user and by system thru pgadmin and I've tried logging in
with my username and password, and I've tried logging in as postgres, but
nothing seems to work.

Any ideas?

--
Susan Lane
DPN, Incorporated
4631 Spring Mountain Road
Las Vegas, NV 89102
Email  suel@dpn.com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com



Re: Pgadmin

From
John Clark Naldoza y Lopez
Date:
Susan Lane wrote:
>
> I've posted this on the INTERFACES list, but haven't recieved any response,
> so hopefully someone here can help me.
>
> I've downloaded pgadmin along with MDAC 2.6, psql ODBC driver, and windows
> installer.  I can't even get connected.  It's giving me a password error
> "Incorrect password: Connection to datasource: XXX failed!"  I've tried to
> set up my DSN by user and by system thru pgadmin and I've tried logging in
> with my username and password, and I've tried logging in as postgres, but
> nothing seems to work.
>
> Any ideas?
>


If so, have you set-up your Database backend to accept connections from
TCP/IP and allowing connections from your machine???  hint (pg_hba.conf)

BTW what version of PostgreSQL are you running and what ODBC driver
version are you using?

Hope that helps.

Cheers,


John Clark
--
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3112            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: njclark@ntsp.nec.co.jp                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds