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@iol.ie