Re: pgAdmin/ODBC errors.

> -----Original Message-----
> From: Contejean, TiJana [mailto:tijana(dot)contejean(at)wcg(dot)com]
> Sent: 05 September 2001 15:03
> To: 'Dave Page'
> Subject: RE: [ODBC] pgAdmin/ODBC errors.
>
>
> Hello Dave,
> That info helped.
> However,I am trying to get into the mirrored site, and my
> system either hangs, or I keep getting referenced to the
> Parent Directory. I tried to download each different version
> and was unsuccesfull. Also, I tried this website before I had
> even found ODBC+.

I cannot help you with this any further. I don't run any of the ftp servers
and can only make suggestions. The mirror I mentioned is the UK Sunsite run
by Imperial College London on a seriously big Sun server and certainly
should have the required capacity to handle your download. I have just
double checked the URL and found the ODBC directories as expected.

> I now know, there is some problem with my
> ODBC Driver, but I have the Driver configured as PostgreSQL.
> It's supposedly trying to configure the PostgreSQL ODBC+
> Driver, and for some reason, it is unable. I will play with
> trying to download from the mirror site again, but before I
> do.

From the ODBC Datasource Administrator control panel applet, select the
System DSN tab. Now click the Add button. From the list, scroll down and
look for 'PostgreSQL'. If it is not there then the driver is not correctly
installed. If it is then select it and fill in the database name and server
name. Click the Driver button and ensure that Recognise Unique Indexes is
checked, and Read-Only is cleared. Click OK. Click the Datasource button.
Ensure that Read-Only is cleared and that both options in the OID Options
frame are checked. Click OK on all dialogues and then you should be able to
run pgAdmin.

>What is phgpgAdmin? Someone told me this tool and also
> pgAccess was suppose to work better than pgAdmin.

phppgAdmin is a similar tool written in PHP. pgAccess is similar to MS
Access. I will not comment on which products I think are better or worse,
they are just different. Suffice it to say, despite large numbers of pgAdmin
users, we get very few problems reported.

> Do you know anything about the two?
> The reason I ask is, we(my company) chose PostgreSQL over
> Oracle for a test database we want to hopefully turn over to
> production. My job as the DBA in my department is to create a
> database that could eventually be an internal website
> database that will keep track, and also keep a record of all
> the changes that our programmers do on a particular project.
> We are trying to eventually be able to send accepts and
> rejects from a project manager approval to resubmits. I was
> told that pgAdmin, as well as the other two tools were
> possible GUI tools that would help me to do this. I've
> already installed the PostgreSQL server database, and through
> a GUI called Putty, was able to connect to the server, which
> is running Linux, through my Windows interface and create a
> database within PostgreSQL called "chgrqst". Now that I have
> the database created through psql, I wanted to try and get
> fimilar with pgAdmin to help me implement changes, accepts,
> rejects, and re-submits from a submittor, programmer, and
> project manager perspective.
> Before I go into all this configuring for pgAdmin, is it
> really the tool I need?

Putty is an ssh client, and is merely a tool for securely logging onto a
remote system. I use it myself for logging on to remote servers.

pgAdmin is a suitable tool for creating, developing and maintaining
databases on PostgreSQL. You may find that our new version, pgAdmin II is
better suited to your needs though. It can be downloaded from
http://pgadmin.postgresql.org/ and is proving to be very stable (despite
being preview code) and offers support for objects such as Rules, Type,
Aggregates and Operators that pgAdmin doesn't. pgAdmin II also doesn't
require the use of DSN's. It will install the required ODBC driver with the
main program and only requires you to supply a username, password,
hostname/IP & port number to log on.

Regards, Dave.

> -----Original Message-----
> From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> Sent: Wednesday, September 05, 2001 2:12 AM
> To: 'Contejean, TiJana'
> Cc: 'pgsql-odbc(at)postgresql(dot)org'
> Subject: RE: [ODBC] pgAdmin/ODBC errors.
>
>
>
>
> > -----Original Message-----
> > From: Contejean, TiJana [mailto:tijana(dot)contejean(at)wcg(dot)com]
> > Sent: 04 September 2001 19:14
> > To: 'Dave Page'
> > Subject: RE: [ODBC] pgAdmin/ODBC errors.
> >
> >
> > Hello Again.
> > I think I only have 2 more questions, hopefully!!!! The first
> > is, where do I find the .odbc.ini file? I have been looking
> > for that for quite some time. It shows on the odbc config
> > white pages that I need to edit this file. I have checked
> > everywhere, and I am unable to find it.
>
> This file is used on *nix systems only. In Windows, the
> settings are stored in the registry. You should not need to
> edit it to get things working.
>
> > Also, how do I log
> > onto your ftp site. It does not take anonymous logins, and
> > the one I enter, which is my network password, doesn't work.
> > Am I doing something wrong. I've even tried to use my
> > username and use the password for the anonymous login.
>
> I don't have an ftp site, so I can only think you mean
> ftp.postgresql.org which is often busy and will refuse
> anonymous connections. As as said in my previous email, try a
> mirror such as
> http://sunsite.org.uk/Mirrors/ftp.postgresql.org/pub/odbc/.
>
> > I am
> > thinking about just re-installing the original PostgreSQL
> > Driverand see where that takes me.
>
> The driver you had originally was the psqlodbc+ driver which
> is not the official PostgreSQL driver. If you can't get that
> working, you'll need to take it up with the maintainer - his
> site is on www.greatbridge.org.
>
> > I've already found the
> > driver path, now I just need to configure this .odbc.ini
> > file. Also, you stated I didn't need the File DSN
> > configured,but somehow it's not allowing me to access pgAdmi
> > without it.
>
> I wrote 90% of pgAdmin and can guarantee you that is *does
> not* require File DSNs to work, or even have any code in it
> to allow them to be used at all.
>
> > I still show the user and system dsn configured,
> > everytime I pull up odbc Drivers in the control panel, but
> > when I try to logon to pgAdmin, it doesn't even give me an
> > option. If I go to the drop-down box, it's just empty,
> > nothing to choose from. Is there something else I am not doing?
>
> If the dropdown box is empty, then it means that the DSNs you
> have setup are not using a recognised PostgreSQL ODBC driver.
> this usually happens when people select 'SQL Server' or
> 'Oracle' or something when they create the DSN instead of
> 'PostgreSQL'. Try using the New button on the logon dialogue
> and let pgAdmin configure your DSN for you. There is a minor
> bug in that version that means you may have to restart
> pgAdmin before you see any newly created DSNs though.
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > Sent: Friday, August 31, 2001 11:19 AM
> > To: 'Contejean, TiJana'
> > Cc: 'pgsql-odbc(at)postgresql(dot)org'
> > Subject: RE: [ODBC] pgAdmin/ODBC errors.
> >
> >
> >
> >
> > > -----Original Message-----
> > > From: Contejean, TiJana [mailto:tijana(dot)contejean(at)wcg(dot)com]
> > > Sent: 31 August 2001 17:13
> > > To: 'Dave Page'
> > > Subject: RE: [ODBC] pgAdmin/ODBC errors.
> > >
> > >
> > > Hello, thanks for respondingto my email. I have tried all the
> > > examples you have given me. I thought that would
> definitely do the
> > > trick. Now, I'm getting a new error when I try to
> configure the File
> > > DSN. The error is, General error. Invalid file dsn 'C:\Program
> > > Files\Common Files\ODBC\DataSources\PostgreSQL.dsn
> > > I am getting this message at the start of:
> > > "Type the name of the file datasource you want to save this
> > > connection to. Or, find the location to save to by clicking
> > > Browse" Also, I have been getting this error from the start,
> > > even before I use the examples you gave me.-A connection
> > > could not be made using the file data source parameters
> > > entered. Save non-verified file DSN. I tried the examples you
> > > gave me, but I still received an error.
> >
> > Don't worry about creating file DSNs - pgAdmin doesn't use
> > them anyway. Just create a single User *or* system DSN to
> get started.
> >
> > > This is like the
> > > hardest gui I've ever installed.
> >
> > Actually, pgAdmin (ie. the GUI) is already installed. It's
> > the ODBC driver manager (the bit Microsoft wrote) you're
> > having trouble with.
> >
> > > I already have the PostgreSQL
> > > ODBC+ Driver, the msi-installer, and I've already
> > downloaded pgAdmin.
> >
> > I can't help you with the the ODBC+ driver, I only package
> > and use the 'official' PostgreSQL driver - I would suggest
> > you try that
> > (http://sunsite.org.uk/Mirrors/ftp.postgresql.> org/pub/odbc/).
> >
> >
> > > ODBC+ I've
> > > already configured the User
> > DSN and the System DSN, but when
> > > I'm trying to configure File DSN, I keep getting either one
> > > of these errors.
> >
> > Like I said, File DSNs are no use to you, just try getting
> > either a System or User dsn sorted first - you don't need one
> > of each or anything like that.
> >
> > Regards, Dave.
> >
>