From: | ray <ray(at)aarden(dot)us> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Defining a Connection String in Windows XP |
Date: | 2010-12-13 19:30:29 |
Message-ID: | b3581a1f-8a26-42f8-b96d-1c35d81c14a0@o14g2000prn.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Dec 13, 1:15 pm, r(dot)(dot)(dot)(at)iol(dot)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 localhost (without quotes).
>
> Yes, that's right.
>
> > For Database, I don t know if this should be the name of a database
> > inside of my pgsql server or something else.
>
> Yes, it's the specific database to which you want to connect.
>
> > When I run:
> > Driver={PostgreSQL};Server=localhost;Port=5432;Database=myDataBase;Uid=user101;Pwd=pw101;
> > I get a message window that says [Microsoft][ODBC Driver Manager]
> > Data source name not found and no default driver specified .
>
> What you're doing above is creating a DSN-less connection. I haven't
> done it that way, but have had no problems when creating a DSN first. Go
> to Administrative Tools -> Data sources (ODBC) and create a data source
> for the database. You can then use a connection string something like this:
>
> dsn=yourDsnName;uid=myUsername;pwd=myPassword;
>
> HTH,
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> r(dot)(dot)(dot)(at)iol(dot)ie
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
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
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Cassidy | 2010-12-13 20:06:28 | Re: Defining a Connection String in Windows XP |
Previous Message | Raymond O'Donnell | 2010-12-13 19:15:51 | Re: Defining a Connection String in Windows XP |