Thread: pgAdmin problems
Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0 I hope I installed all the components (for a Win98) install correctly. The pg database is on a remote server, accessed across the internet. I am new to this ODBC stuff, but the past few months have been using psql and php3 interfaces (both local access) to 6.5.3 database. Anyway, I created a datasource in ODBC, but when I try to use it with pgAdmin (either version), I get: Error 3706, ADO could not find the specified provider. function: frmODBClogon, cmdOK_Click. If I try to link to the same source with Access'97; I get this: ODBC--call failed. IDENT authentication failed for user 'gwacl' (#210). Are these both the same problem? Frank PS: The start-menu shortcut's created by pgAdmin install don't point to anything!
Frank Bax wrote: > > Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0 > I hope I installed all the components (for a Win98) install correctly. > The pg database is on a remote server, accessed across the internet. > I am new to this ODBC stuff, but the past few months have been using > psql and php3 interfaces (both local access) to 6.5.3 database. > > Anyway, I created a datasource in ODBC, but when I try to use it with > pgAdmin (either version), I get: > Error 3706, ADO could not find the specified provider. > function: frmODBClogon, cmdOK_Click. > > If I try to link to the same source with Access'97; I get this: > ODBC--call failed. > IDENT authentication failed for user 'gwacl' (#210). > > Are these both the same problem? probably. have you configured access from your client in pg_hba.conf to something like password (or possibly crypt). I doubt you have identd running on your ODBC client machine. ----------------- Hannu
I'm sorry, but I don't understand the examples in pg_hba.conf file. The file contains only these non-commented lines: local all trust host all 127.0.0.1 255.255.255.255 trust host all 0.0.0.0 0.0.0.0 password When I change password to crypt or ident, then error message in Access changes accordingly. When I change the last line to: host all xxx.xxx.xxx.xxx 255.255.255.255 trust Where xxx.xxx.xxx.xxx is client's dynamically assigned IP address, I was able to connect with Access, but pgAdmin still produced the same message mentioned below in my first message. Changing the last line to host all xxx.xxx.xxx.xxx 255.255.255.255 password gives the password authentication error in Access. In ODBC (on Win98 client side), I have username and password of the user that owns the database I'm trying to access. Did I need to mention that the server is running on OpenBSD? Frank At 12:03 AM 4/02/00 +0300, you wrote: >Frank Bax wrote: >> >> Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0 >> I hope I installed all the components (for a Win98) install correctly. >> The pg database is on a remote server, accessed across the internet. >> I am new to this ODBC stuff, but the past few months have been using >> psql and php3 interfaces (both local access) to 6.5.3 database. >> >> Anyway, I created a datasource in ODBC, but when I try to use it with >> pgAdmin (either version), I get: >> Error 3706, ADO could not find the specified provider. >> function: frmODBClogon, cmdOK_Click. >> >> If I try to link to the same source with Access'97; I get this: >> ODBC--call failed. >> IDENT authentication failed for user 'gwacl' (#210). >> >> Are these both the same problem? > >probably. > >have you configured access from your client in pg_hba.conf to something >like password (or possibly crypt). I doubt you have identd running on >your ODBC client machine. > >----------------- >Hannu > >
> -----Original Message----- > From: Frank Bax [mailto:fbax@execulink.com] > Sent: 01 April 2000 20:27 > To: pgsql-interfaces@postgresql.org > Subject: [INTERFACES] pgAdmin problems > > > Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0 > I hope I installed all the components (for a Win98) install correctly. > The pg database is on a remote server, accessed across the internet. > I am new to this ODBC stuff, but the past few months have been using > psql and php3 interfaces (both local access) to 6.5.3 database. > > Anyway, I created a datasource in ODBC, but when I try to use it with > pgAdmin (either version), I get: > Error 3706, ADO could not find the specified provider. > function: frmODBClogon, cmdOK_Click. Make sure you have an up-to-date version of MDAC installed. You can get it from http://www.microsoft.com/data/mdac2.htm. > > PS: The start-menu shortcut's created by pgAdmin install > don't point to > anything! Yes they do, but they are not regular shortcuts. They point to hidden 'launcher' executables that run pgAdmin for you. They also deal with 'install on first use' and application advertising which are new Win2K things (though aren't used by pgAdmin yet). Regards, Dave. -- "I find an axe is the most satisfying, but really any good weapon will do." - Sacha Roscoe, explaining basic systems administration. http://www.vale-housing.co.uk/ (Work) http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)