pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedsetup of pgadmin
10+ messages / 4 participants
[nested] [flat]
* setup of pgadmin
@ 2000-01-13 13:02 swift@eturnkey.com
0 siblings, 0 replies; 10+ messages in thread
From: swift@eturnkey.com @ 2000-01-13 13:02 UTC (permalink / raw)
To: pgsql-interfaces
I know that the setup for pgadmin is pretty simple. I have MDC 2.1
installed, I have postODBC installed, and I have pgadmin installed.
However when I try to access a database I continue to get error message
that states:
"The selected database is not a PostgreSQL v6.5.x system!"
However, I am using 6.5.5
On the subsequent tries I get:
"This database does not appear to be in the version 6.4.x format!"
I was reading through the documentation for postODBC and noticed that I
have to have pg_hba.conf to allow remote access and I must start postmaster
-i
Will this fix the above problems?
Thank you,
Kenneth Swift
swift@eturnkey.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Setup of PGAdmin
@ 2000-01-13 13:20 swift@eturnkey.com
0 siblings, 1 reply; 10+ messages in thread
From: swift@eturnkey.com @ 2000-01-13 13:20 UTC (permalink / raw)
To: pgsql-interfaces
I know that the setup for pgadmin is pretty simple. I have MDC 2.1
installed, I have postODBC installed, and I have pgadmin installed.
However when I try to access a database I continue to get error message
that states:
"The selected database is not a PostgreSQL v6.5.x system!"
However, I am using 6.5.5
On the subsequent tries I get:
"This database does not appear to be in the version 6.4.x format!"
I was reading through the documentation for postODBC and noticed that I
have to have pg_hba.conf to allow remote access and I must start postmaster
-i
Will this fix the above problems?
Thank you,
Kenneth Swift
swift@eturnkey.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Setup of PGAdmin
@ 2000-01-14 07:09 Michael Meskes <meskes@postgreSQL.org>
parent: swift@eturnkey.com
0 siblings, 0 replies; 10+ messages in thread
From: Michael Meskes @ 2000-01-14 07:09 UTC (permalink / raw)
To: swift@eturnkey.com; +Cc: pgsql-interfaces
On Thu, Jan 13, 2000 at 01:20:27PM +0000, swift@eturnkey.com wrote:
> However when I try to access a database I continue to get error message
> that states:
>
> "The selected database is not a PostgreSQL v6.5.x system!"
Me too.
> I was reading through the documentation for postODBC and noticed that I
> have to have pg_hba.conf to allow remote access and I must start postmaster
> -i
Yes, you have to allow tcp connections.
> Will this fix the above problems?
It certainly does not for me. Can you access your database through ODBC
alone? For instance is M$ Access able to get the data?
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Setup of PGAdmin
@ 2000-01-14 08:46 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 1 reply; 10+ messages in thread
From: Dave Page @ 2000-01-14 08:46 UTC (permalink / raw)
To: pgsql-interfaces
Extra Info: Michael has tested a small app for me on his system that
connects to PostgreSQL and attempts to execute SELECT version() (as pgAdmin
does) using ADO. The SELECT failed giving an error:
Error 430 - Class does not support Automation or does not support expected
interface.
> -----Original Message-----
> From: Michael Meskes [mailto:meskes@postgreSQL.org]
> Sent: 14 January 2000 07:09
> To: swift@eturnkey.com
> Cc: pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] Setup of PGAdmin
>
>
> On Thu, Jan 13, 2000 at 01:20:27PM +0000, swift@eturnkey.com wrote:
> > However when I try to access a database I continue to get
> error message
> > that states:
> >
> > "The selected database is not a PostgreSQL v6.5.x system!"
>
> Me too.
This now appears to almost certainly be a problem with MDAC/Windows (which
are not unheard of ;-))
Some questions to you both:
- Have you run earlier versions of pgAdmin?
- What versions of DCOM and MDAC have you installed (2.1.1.3711.11 is the
current version)?
- What language & version of Windows are you running?
- What version of Internet Explorer is installed?
- Do you have (and what version) MS Office installed?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Setup of PGAdmin
@ 2000-01-14 20:46 Michael Meskes <meskes@postgresql.org>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Michael Meskes @ 2000-01-14 20:46 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: pgsql-interfaces
On Fri, Jan 14, 2000 at 08:46:43AM -0000, Dave Page wrote:
> - Have you run earlier versions of pgAdmin?
Not on this system.
> - What versions of DCOM and MDAC have you installed (2.1.1.3711.11 is the
> current version)?
I have no idea. How can I check this?
> - What language & version of Windows are you running?
German Windows 98.
> - What version of Internet Explorer is installed?
There should be none installed since I explicitely removed it. But with
Windows you never know.
> - Do you have (and what version) MS Office installed?
Yes. 97.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Setup of PGAdmin
@ 2000-01-17 20:49 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 1 reply; 10+ messages in thread
From: Dave Page @ 2000-01-17 20:49 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Michael Meskes [mailto:meskes@postgreSQL.org]
> Sent: 14 January 2000 20:46
> To: Dave Page
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: Re: [INTERFACES] Setup of PGAdmin
>
>
> On Fri, Jan 14, 2000 at 08:46:43AM -0000, Dave Page wrote:
> > - Have you run earlier versions of pgAdmin?
>
> Not on this system.
>
> > - What versions of DCOM and MDAC have you installed
> (2.1.1.3711.11 is the
> > current version)?
>
> I have no idea. How can I check this?
I'm not completely sure to be honest. The easiest way is to double check
what you downloaded.Alternatively, under (in the registry)
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess there is a value called
Version. On my system it's value is 2.1.1a.
> > - What language & version of Windows are you running?
>
> German Windows 98.
>
> > - What version of Internet Explorer is installed?
>
> There should be none installed since I explicitely removed
> it. But with
> Windows you never know.
Is this possible in the German version? There is no way to do this in the UK
English version (that I have ever found anyway).
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Setup of PGAdmin
@ 2000-01-18 13:39 Michael Meskes <meskes@postgreSQL.org>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Michael Meskes @ 2000-01-18 13:39 UTC (permalink / raw)
To: pgsql-interfaces
On Mon, Jan 17, 2000 at 08:49:49PM -0000, Dave Page wrote:
> I'm not completely sure to be honest. The easiest way is to double check
> what you downloaded.Alternatively, under (in the registry)
It is 2.0 that I downloaded. But I do not remember the patchlevel.
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess there is a value called
> Version. On my system it's value is 2.1.1a.
This key has the value 2.0.3 on my machine.
> Is this possible in the German version? There is no way to do this in the UK
> English version (that I have ever found anyway).
Well let's say I do not see it anywhere in the software display. I hvae no
idea what I really deleted.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Setup of PGAdmin
@ 2000-01-18 16:40 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Dave Page @ 2000-01-18 16:40 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Michael Meskes [mailto:meskes@postgreSQL.org]
> Sent: 18 January 2000 13:40
> To: 'pgsql-interfaces@postgresql.org'
> Subject: Re: [INTERFACES] Setup of PGAdmin
>
>
> On Mon, Jan 17, 2000 at 08:49:49PM -0000, Dave Page wrote:
> > I'm not completely sure to be honest. The easiest way is to
> double check
> > what you downloaded.Alternatively, under (in the registry)
>
> It is 2.0 that I downloaded. But I do not remember the patchlevel.
>
> > HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess there is a
> value called
> > Version. On my system it's value is 2.1.1a.
>
> This key has the value 2.0.3 on my machine.
Can you try installing 2.1 SP2 please. It is listed on
http://www.microsoft.com/data
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] Setup of PGAdmin
@ 2000-01-19 16:26 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Dave Page @ 2000-01-19 16:26 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Michael Meskes [mailto:meskes@postgresql.org]
> Sent: 19 January 2000 07:52
> To: Dave Page
> Subject: Re: [INTERFACES] Setup of PGAdmin
>
>
> On Tue, Jan 18, 2000 at 04:40:22PM -0000, Dave Page wrote:
> > Can you try installing 2.1 SP2 please. It is listed on
> > http://www.microsoft.com/data
>
> I will try. But right now I cannot download ~6meg over my modem.
>
> As soon as I find time I will.
Yes, it's annoying isn't it? Unfortunately there are some bugs in 2.0 that
we have stumbled across before.
> Or is there a smaller upgrade package?
Not that I've ever come across. We don't distribute the correct version with
pgAdmin for the obvious increase in download size (and you should only need
to install MDAC once).
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] Setup of PGAdmin
@ 2000-01-20 19:52 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Dave Page @ 2000-01-20 19:52 UTC (permalink / raw)
To: 'Michael Meskes' <michael@fam-meskes.de>; +Cc: pgsql-interfaces
(CC'd to pgsql-interfaces)
> -----Original Message-----
> From: Michael Meskes [mailto:michael@fam-meskes.de]
> Sent: 20 January 2000 15:16
> To: dpage@vale-housing.co.uk
> Subject: pgAdmin
>
>
> Hi Dave,
>
> I just got myself the latest MDAC and guess what, pgAdmin
> runs like a charm.
Excellent!! It's a shame it took so long to figure out. I will look at
clarifying the exact requirements for running pgAdmin on the our website.
> I love this program! Great work.
Thanks. We try ;-)
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2000-01-20 19:52 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-13 13:02 setup of pgadmin swift@eturnkey.com
2000-01-13 13:20 Setup of PGAdmin swift@eturnkey.com
2000-01-14 07:09 ` Re: [INTERFACES] Setup of PGAdmin Michael Meskes <meskes@postgreSQL.org>
2000-01-14 08:46 RE: [INTERFACES] Setup of PGAdmin Dave Page <dpage@vale-housing.co.uk>
2000-01-14 20:46 ` Re: [INTERFACES] Setup of PGAdmin Michael Meskes <meskes@postgresql.org>
2000-01-17 20:49 RE: [INTERFACES] Setup of PGAdmin Dave Page <dpage@vale-housing.co.uk>
2000-01-18 13:39 ` Re: [INTERFACES] Setup of PGAdmin Michael Meskes <meskes@postgreSQL.org>
2000-01-18 16:40 RE: [INTERFACES] Setup of PGAdmin Dave Page <dpage@vale-housing.co.uk>
2000-01-19 16:26 RE: [INTERFACES] Setup of PGAdmin Dave Page <dpage@vale-housing.co.uk>
2000-01-20 19:52 Re: [INTERFACES] Setup of PGAdmin Dave Page <dpage@vale-housing.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox