Re: Defining a Connection String in Windows XP

> -----Original Message-----
> From: Susan Cassidy [mailto:scassidy(at)stbernard(dot)com]
> Sent: Monday, December 13, 2010 2:06 PM
> To: ray; pgsql-general(at)postgresql(dot)org
> Subject: RE: [GENERAL] Defining a Connection String in Windows XP
>
> >Ray,
> >
> >Thank you for responding. OK, that was my first trip into DSN setup
> >and I got lost:
> >The first step is to choose and existing MS driver for an Office app
> >or 'Add' one from this 'User DSN' tab. The other tabs are:
> >System dSN, File DSN, Drivers, Tracing, and Connection Pooling.
> >I did not see a pgsql listed in any - what is the next step (or two)?
> >
> >ray
>
> I usually use a System DSN. If, when you click Add, you don't see
> 'PostgreSQL ANSI' as one of the choices, you don't have the ODBC driver
> installed. If you do, just fill in the boxes with the database name,
> password, etc.
>
> Susan C.
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
This is great!
Just for reference, the bat file would not run because there was not an
existing pgsql driver. The msi file worked right off.

I used a System DSN and it worked.
Now to figure out what to do with it.
BTW, what are some of the considerations for choosing DSN types System,
File, User?

Thank you very much,
ray