Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin/ODBC errors.

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Contejean, TiJana'" <tijana(dot)contejean(at)wcg(dot)com>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: pgAdmin/ODBC errors.
Date: 2001-08-31 16:19:06
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2DF0@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----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.


pgsql-odbc by date

Next:From: Keith GrayDate: 2001-09-03 06:40:51
Subject: Auto Commit
Previous:From: Dave PageDate: 2001-08-31 12:19:37
Subject: Re: CommLog on Win32 ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group