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 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...@iol.ie
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.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
