Re: Defining a Connection String in Windows XP

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
rod(at)iol(dot)ie