greg@xxxxxxxxxxxxxxxxxxx wrote:
-------- Original Message --------
Subject: Re: [GENERAL] SQLConnect failure
From: Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>
Date: Mon, April 02, 2007 2:54 pm
To: greg@xxxxxxxxxxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
In response to greg@xxxxxxxxxxxxxxxxxxx:
We have code that has been using MSDE/SQL Server successfully for
years,
and are adding Postgres support. Doing a SQLConnect to connect to a
local Postgres server works fine, but if we try to connect to a remote
system, the SQLConnect fails, and we get an error code that seems to
indicate "The value specified for the argument UserName or the value
specified for the argument Authentication violated restrictions defined
by the data source.".
We can connect via pgadmin to the remote system, so we believe all the
little .conf files should be correct, but can't get in
programmatically. Any pointers on where to look?
The logs on the PostgreSQL server would be a good place to start.
This sounds suspiciously like a pg_hba.conf misconfig. You might want
to verify its correctness.
Thanks guys. I can connect to the remote server via pgadmin on a
different machine, so I'm pretty sure that the .conf files are correct
(that took awhile, but there are very good diagnostic messages when
they are wrong). When I set the hba, the encryption is set to MD5 -
does that need to be set somewhere on the client side?
What version of the PostgreSQL ODBC driver you are using?
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
