Re: pgAdmin/ODBC errors. - Mailing list pgsql-odbc

From Dave Page
Subject Re: pgAdmin/ODBC errors.
Date
Msg-id 8568FC767B4AD311AC33006097BCD3D61A2DF0@woody.vale-housing.co.uk
Whole thread Raw
In response to pgAdmin/ODBC errors.  ("Contejean, TiJana" <tijana.contejean@wcg.com>)
List pgsql-odbc

> -----Original Message-----
> From: Contejean, TiJana [mailto:tijana.contejean@wcg.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.


pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: CommLog on Win32 ODBC
Next
From: Jochem van Dieten
Date:
Subject: BIND variables & Windows ODBC driver