On Apr 2, 2007, at 4:36 PM, [EMAIL PROTECTED] wrote:
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?
Are the host your running your SQLConnect and the host pgadmin the
same? If not, you probably need to edit your pg_hba.conf file (in
your data directory) to allow connections from the host your code is
running on.
erik jones <[EMAIL PROTECTED]>
software developer
615-296-0838
emma(r)
