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@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
