Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread John R Pierce
On 12/13/10 6:32 PM, ray joseph wrote: 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? all three do the same thing in the end, they specify a ODBC database connection. the system DSN

Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread ray joseph
> -Original Message- > From: Susan Cassidy [mailto:scass...@stbernard.com] > Sent: Monday, December 13, 2010 2:06 PM > To: ray; pgsql-general@postgresql.org > Subject: RE: [GENERAL] Defining a Connection String in Windows XP > > >Ray, > > > >Thank

Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread Susan Cassidy
>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 n

Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread Raymond O'Donnell
On 13/12/2010 19:30, ray wrote: 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 Connect

Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread ray
On Dec 13, 1:15 pm, r...@iol.ie ("Raymond O'Donnell") wrote: > On 13/12/2010 18:46, ray wrote: > > > I do not know if I should leave the {PostgreSQL} as is or should it be > > replaced with something. > > For Server, the connection is on the same machine so I would think the > > value should be loc

Re: [GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread Raymond O'Donnell
On 13/12/2010 18:46, ray wrote: I do not know if I should leave the {PostgreSQL} as is or should it be replaced with something. For Server, the connection is on the same machine so I would think the value should be ‘localhost’ (without quotes). Yes, that's right. For Database, I don’t know i

[GENERAL] Defining a Connection String in Windows XP

2010-12-13 Thread ray
I would like to learn how to set a connection string. I am running pgsql 9.0 on an XP. I found a list of connection string examples: » dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect) (PgSqlConnection) » Npgsql (NpgsqlConnection) » PostgreSQL OLE DB Provider » .NET Framework Data Pro